sql得到当前系统时间得 日期部分
CONVERT(varchar(10),getDate(),120)
昨天
select convert(varchar(10),getdate() – 1,120)
明天
select convert(varchar(10),getdate() + 1,120)
最近七天
select * from tb where 时间字段 >= convert(varchar(10),getdate() – 7,120)
随后七天
select * from tb where 时间字段 <= convert(varchar(10),getdate() + 7,120) and 时间字段 >= 时间字段
上月
select * from tb where month(时间字段) = month(getdate()) – 1
本月
select * from tb where month(时间字段) = month(getdate())
下月
select * from tb where month(时间字段) = month(getdate()) + 1
–昨天
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 * From TableName Where DateDiff(dd, GetDate(), DateTimCol) <= 7
–上周
Select * From TableName Where DateDiff(wk, DateTimCol, GetDate()) = 1
–本周
Select * From TableName Where DateDiff(wk, DateTimCol, GetDate()) = 0
–下周
Select * From TableName Where DateDiff(wk, GetDate(), DateTimCol ) = 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
——————————————————–
本周
select * from tb where datediff(week , 时间字段 ,getdate()) = 0
上周
select * from tb where datediff(week , 时间字段 ,getdate()) = 1
下周
select * from tb where datediff(week , 时间字段 ,getdate()) = -1