将纪元字符串仅保存到mysql日期时间，而不是小时、分钟和秒

CREATE TABLE epoch_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    epoch_datetime DATETIME
);

import mysql.connector
from datetime import datetime

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')

# 创建游标对象
cursor = cnx.cursor()

# 纪元字符串
epoch_string = "1630454400"  # 示例纪元字符串

# 将纪元字符串转换为时间戳
timestamp = int(epoch_string)

# 将时间戳转换为日期时间对象
datetime_obj = datetime.fromtimestamp(timestamp)

# 将日期时间对象保存到数据库
insert_query = "INSERT INTO epoch_data (epoch_datetime) VALUES (%s)"
data = (datetime_obj,)
cursor.execute(insert_query, data)

# 提交更改并关闭连接
cnx.commit()
cursor.close()
cnx.close()