从单个列中为日期、月、年、小时、分钟、秒创建单独的列

import datetime

# 将字符串转换为日期时间类型
date_str = "2022-01-01 12:34:56"
date_time = datetime.datetime.strptime(date_str, "%Y-%m-%d %H:%M:%S")

# 获取日期、月、年、小时、分钟和秒
date = date_time.date()
month = date_time.month
year = date_time.year
hour = date_time.hour
minute = date_time.minute
second = date_time.second

print("日期:", date)
print("月:", month)
print("年:", year)
print("小时:", hour)
print("分钟:", minute)
print("秒:", second)

SELECT DATE(date_time_column) AS date,
       MONTH(date_time_column) AS month,
       YEAR(date_time_column) AS year,
       HOUR(date_time_column) AS hour,
       MINUTE(date_time_column) AS minute,
       SECOND(date_time_column) AS second
FROM your_table;