按日期范围查询

后台开发sql server使用DATEDIFF()函数和GetDate()函数了，取今天、昨天、本周、上周、本月、上月等数据
方法名称：
DATEDIFF ( datepart , startdate , enddate )
释义：计算时间差
datepare值：year | quarter | month | week | day | hour | minute | second | millisecond
startdate：开始日期
enddate ：结束日期
GetDate()：获取当前的系统日期

例子中表名为tablename ,条件字段名为time

查询今天

SELECT * FROM tablename where DATEDIFF(day,time,GETDATE())=0

查询昨天

SELECT * FROM tablename where DATEDIFF(day,time,GETDATE())=1

查询本周

SELECT * FROM tablename where datediff(week,time,getdate())=0

查询上周

SELECT * FROM tablename where datediff(week,time,getdate())=1

查询本月

SELECT * FROM tablename where DATEDIFF(month,time,GETDATE())=0

查询上月

SELECT * FROM tablename where DATEDIFF(month,time,GETDATE())=1

查询本季度的

select * from T_InterViewInfo where datediff(QQ,time,getdate())=0

oracle查询某天之前3个月期间的数据

WHERE SALE_DATE > ADD_MONTHS(TO_DATE('2019-03', 'yyyy-mm'),-3) and SALE_DATE < TO_DATE('2019-03', 'yyyy-mm') as SALE_COUNT