查询条件实现:
>=(大于等于) 开始时间的00:00:00
< (小于)结束时间后一天的00:00:00
1. yyyy-MM-dd 格式,eg: 2020-06-30
select * from a
where create_time >= DATE_FORMAT('2020-06-30','%Y-%m-%d')
and create_time < DATE_ADD('2020-06-30',INTERVAL 1 DAY);
2. yyyy-MM-dd HH:mm:ss 格式,eg: 2020-06-30 00:00:00
select * from a
where create_time >= DATE_FORMAT('2020-06-30 00:00:00','%Y-%m-%d')
and create_time < DATE_ADD(DATE_FORMAT('2020-06-30 23:59:59','%Y-%m-%d'),INTERVAL 1 DAY);