加减日、月、年
date 类型的数据可以直接加减天数,加减月份需要使用 add_months 函数,同时也可以使用 add_days 加减天数。示例语句如下所示:
SELECT * from tablename where
createtime between add_days (now(), -7) and now() order by createtime desc 7天
select * from tablename where
createtime between add_months(now(),-1) and now() order by createtime desc 一个月
select * from tablename where
createtime between add_months(now(),-1*12) and now() order by createtime desc 一年
addDate函数
30分钟内
dateadd(minute,-30,getdate())
24小时内
adddate(hour,-24,getdate())