mysql导入access数据库时间格式

import pandas as pd
import mysql.connector

# 连接到Access数据库
access_conn = mysql.connector.connect(
  host='localhost',
  user='your_username',
  password='your_password',
  database='your_access_database'
)

# 读取Access数据库中的数据
access_query = "SELECT * FROM your_table"
access_data = pd.read_sql_query(access_query, access_conn)

# 转换时间格式
access_data['your_datetime_column'] = pd.to_datetime(access_data['your_datetime_column']).dt.strftime('%Y-%m-%d %H:%M:%S')

# 连接到MySQL数据库
mysql_conn = mysql.connector.connect(
  host='localhost',
  user='your_username',
  password='your_password',
  database='your_mysql_database'
)

# 导入到MySQL数据库
mysql_cursor = mysql_conn.cursor()
mysql_cursor.executemany('INSERT INTO your_table (your_datetime_column) VALUES (%s)', access_data['your_datetime_column'].tolist())
mysql_conn.commit()

# 关闭连接
access_conn.close()
mysql_conn.close()