excel导入mysql时间

import pandas as pd
import mysql.connector

# 读取Excel文件
df = pd.read_excel('data.xlsx')

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

# 连接MySQL数据库
conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = conn.cursor()

# 插入数据
for index, row in df.iterrows():
    query = "INSERT INTO table_name (时间) VALUES (%s)"
    cursor.execute(query, (row['时间'],))

conn.commit()
cursor.close()
conn.close()

import pandas as pd
import mysql.connector
from datetime import timezone

# 读取Excel文件
df = pd.read_excel('data.xlsx')

# 转换时间格式并去除时区信息
df['时间'] = pd.to_datetime(df['时间']).dt.tz_localize(None).dt.strftime('%Y-%m-%d %H:%M:%S')

# 连接MySQL数据库
conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
cursor = conn.cursor()

# 插入数据
for index, row in df.iterrows():
    query = "INSERT INTO table_name (时间) VALUES (%s)"
    cursor.execute(query, (row['时间'],))

conn.commit()
cursor.close()
conn.close()