Sqlserver中获取本周、上周、本月等日期数据的Sql语句
摘要:本周 select * from tb where datediff(week , 时间字段 ,getdate()) = 0 上周 select * from tb where datediff(week , 时间字段 ,getdate()) = 1 下周 select * from tb where datediff(week , 时间字段 ,getdate()) = -1 --------------
本周
select * from tb where datediff(week , 时间字段 ,getdate()) = 0
上周
select * from tb where datediff(week , 时间字段 ,getdate()) = 1
下周
select * from tb where datediff(week , 时间字段 ,getdate()) = -1
----------------------------------------------------------------------------------------
--上月
Select * From TableName Where DateDiff(mm, DateTimCol, GetDate()) = 1
--本月
Select * From TableName Where DateDiff(mm, DateTimCol, GetDate()) = 0
--下月
Select * From TableName Where DateDiff(mm, GetDate(), DateTimCol ) = 1
昨天:dateadd(day,-1,getdate()) 明天:dateadd(day,1,getdate()) 上月:month(dateadd(month, -1, getdate())) 本月:month(getdate()) 下月:month(dateadd(month, 1, getdate()))
---------------------------------------------------------------------------------
--昨天
Select * From TableName Where DateDiff(dd, DateTimCol, GetDate()) = 1
--明天
Select * From TableName Where DateDiff(dd, GetDate(), DateTimCol) = 1
--最近七天
Select * From TableName Where DateDiff(dd, DateTimCol, GetDate()) <= 7
---------------------------------------------------------------------------
当前年
select 提出日期, datepart(year,getdate()) as 当前年 from 供方资料表
前一年
select 提出日期, datepart(year,getdate())-1 as 当前年 from 供方资料表
后一年
select 提出日期, datepart(year,getdate())+1 as 当前年 from 供方资料表