今天: where datediff(day,日期字段,getdate())=0昨天: where datediff(day,日期字段,getdate())=1这一周: where datediff(week,日期字段,getdate())=0当月: where datediff(month,日期字段,getdate())=0
select substring(cast(Getdate() as varchar(10)),1,7) 或 select subString(convert(varchar(10),Getdate(),121),1,7)
应该是 select DATEDIFF(day, AppDate, GETDATE)<=7 AND DATEDIFF(week, AppDate, GETDATE)=0
set datefirst 1 --sunday is the firstday datediff(day,日期字段,getdate())<=datepart(weekday,getdate()) set datefirst 2 -- datediff(day,日期字段,getdate())<=datepart(weekday,getdate())-1
where datediff(day,日期字段,getdate())=0昨天:
where datediff(day,日期字段,getdate())=1这一周:
where datediff(week,日期字段,getdate())=0当月:
where datediff(month,日期字段,getdate())=0
或
select subString(convert(varchar(10),Getdate(),121),1,7)
datediff(day,日期字段,getdate())<=datepart(weekday,getdate())
set datefirst 2 --
datediff(day,日期字段,getdate())<=datepart(weekday,getdate())-1