python mysql

Question

python3连接MYSQL查询问题
代码如下,执行sql1正常，执行sql2就不行了，这个时间格式怎么改都不对,请教一下如何处理。
写DT>(2023-08-05) and DT<(2023-09-01) 可以执行，
写DT>(2023-08-05 00:00:00) and DT<(2023-09-01 00:00:00)就报错了

import pandas as pd
import sqlalchemy as sql
import time
import datetime
engine = sql.create_engine('mysql+pymysql://aaa1:aaaa@127.0.0.1:3306/db_his')
#查询语句
sql1 = '''SELECT * FROM db_his.float where DT>(2023-08-05) and DT<(2023-09-01) order by DT  desc limit 1'''
sql2 = '''SELECT * FROM db_his.float where DT>(2023-08-05 00:00:00) and DT<(2023-09-01 00:00:00) order by DT  desc limit 1'''
df = pd.read_sql(sql1,engine)
print(df)

数据库结构如下

Answer 1

看一下你的DT是什么类型的字段