SqlServer 查询最近一段范围中的数据

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,GetDate()) <= 7

--随后七天

Select * From TableName Where DateDiff(dd,DateTimCol) <= 7

--上周

Select * From TableName Where DateDiff(wk,GetDate()) = 1

--本周

Select * From TableName Where DateDiff(wk,GetDate()) = 0

--下周

Select * From TableName Where DateDiff(wk,DateTimCol ) = 1

--上月

Select * From TableName Where DateDiff(mm,GetDate()) = 1

--本月

Select * From TableName Where DateDiff(mm,GetDate()) = 0

--下月

Select * From TableName Where DateDiff(mm,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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!