Mysql根据datatime类型字段查询介于某个时间段之间的数据

语法:

SELECT * FROM [表名] WHERE [字段名] BETWEEN 'yyyy-MM-dd hh:mm:ss.000' AND 'yyyy-MM-dd hh:mm:ss.999';

ex:

select * from xxl_job_log where handle_time between '2020-07-01 00:00:00.000' and '2020-07-31 23:59:59.999';