SELECT * FROM lt_dingtalk_signin WHERE third_party_unit_id = 240 and create_time BETWEEN '2023-04-01' and '2023-04-20' SELECT * FROM lt_dingtalk_signin WHERE third_party_unit_id = 240 and Date(create_time) BETWEEN '2023-04-01' and '2023-04-20'
之前搞的项目全部都没加这个函数，加一个Date()函数即可