语法:
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';
语法:
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';