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()函数即可