1.查询的是日期前后距离一共14天的内容
select * from user
where DATEDIFF(createDate,now()) < 7
2.查询指定时间段的内容
select * from user
where date BETWEEN '2021-02-23' and '2021-02-25'
1.查询的是日期前后距离一共14天的内容
select * from user
where DATEDIFF(createDate,now()) < 7
2.查询指定时间段的内容
select * from user
where date BETWEEN '2021-02-23' and '2021-02-25'