在SQL to Python中挑选两个日期之间具有相同时间的行

import pymysql

# 连接到数据库
conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')

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

start_date = '2022-01-01'
end_date = '2022-01-31'

# 构建SQL查询语句
sql = f"SELECT * FROM table_name WHERE DATE_FORMAT(date_column, '%H:%i:%s') BETWEEN '{start_date} 00:00:00' AND '{end_date} 23:59:59'"

# 执行SQL查询
cursor.execute(sql)

# 获取查询结果
results = cursor.fetchall()

# 打印查询结果
for row in results:
    print(row)

# 关闭游标和连接
cursor.close()
conn.close()