数据展示
YYYY-MM-DD HH:mm:ss格式查询
- 写法一:
select * from user where create_time between '2020-01-01 00:00:00' and '2020-02-01 00:00:00';
- 写法二:
select * from user where create_time >= '2020-01-01 00:00:00' and create_time < '2020-02-01 00:00:00';
非YYYY-MM-DD HH:mm:ss格式
利用date_format函数
select * from user where date_format(create_time, '%Y-%m-%d') between '2020-01-01' and '2020-02-01';
转载:地址