mysql导入excel时间

import pandas as pd
from sqlalchemy import create_engine

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

# 将时间列格式化为MySQL可接受的格式
df['time_column'] = pd.to_datetime(df['time_column']).dt.strftime('%Y-%m-%d %H:%M:%S')

# 连接MySQL数据库
engine = create_engine('mysql+pymysql://username:password@host:port/database')

# 将数据导入MySQL
df.to_sql('table_name', engine, if_exists='replace', index=False)

import pandas as pd
from sqlalchemy import create_engine
from pytz import timezone

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

# 将时间列转换为UTC时区
df['time_column'] = pd.to_datetime(df['time_column']).dt.tz_localize('Asia/Shanghai').dt.tz_convert('UTC')

# 连接MySQL数据库并设置时区
engine = create_engine('mysql+pymysql://username:password@host:port/database?charset=utf8mb4&serverTimezone=UTC')

# 将数据导入MySQL
df.to_sql('table_name', engine, if_exists='replace', index=False)

import pandas as pd
from sqlalchemy import create_engine

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

# 将时间列转换为datetime类型
df['time_column'] = pd.to_datetime(df['time栏'])

# 连接MySQL数据库
engine = create_engine('mysql+pymysql://username:password@host:port/database')

# 将数据导入MySQL
df.to_sql('table_name', engine, if_exists='replace', index=False)