例1:select create_time as time, sum(count) count from url_log WHERE create_time BETWEEN '2022-01-01' and '2022-01-25'
例2:select create_time as time, sum(count) count from url_log WHERE create_time BETWEEN '2022-01-01' and '2022-01-25 00:00:00'
结果:例1和例2查询结果是相同的
结论:当查询mysql时通过年月日查询时,查询的时当天的凌晨时间;例如2022-01-25,实际查询的是2022-01-25 00:00:00'