34,590
社区成员
发帖
与我相关
我的任务
分享
select * from info
where DATEDIFF(dd,DATEADD(day,-7,DATEADD(week, DATEDIFF(week, '', getdate()), '')),titleddtime) =0
or
DATEDIFF(dd,DATEADD(day,-5,DATEADD(week, DATEDIFF(week, '', getdate()), '')),titleddtime) =0
or
DATEDIFF(dd,DATEADD(day,-3,DATEADD(week, DATEDIFF(week, '', getdate()), '')),titleddtime) =0
declare @a datetime;
set @a=GETDATE();
select dateadd(wk,DATEDIFF(wk,0,@a)-1,0)
-- - -!
select * from info
where DATEDIFF(dd,DATEADD(day,-7,DATEADD(week, DATEDIFF(week, '', getdate()), '')),'2011-01-10 00:00:00.000') =0
or
DATEDIFF(dd,DATEADD(day,-5,DATEADD(week, DATEDIFF(week, '', getdate()), '')),'2011-01-10 00:00:00.000') =0
or
DATEDIFF(dd,DATEADD(day,-3,DATEADD(week, DATEDIFF(week, '', getdate()), '')),'2011-01-10 00:00:00.000') =0
select * from info
where titleddtime=DATEADD(day,-7,DATEADD(week, DATEDIFF(week, '', getdate()), ''))
or titleddtime=DATEADD(day,-5,DATEADD(week, DATEDIFF(week, '', getdate()), ''))
or titleddtime=DATEADD(day,-3,DATEADD(week, DATEDIFF(week, '', getdate()), ''))
-- 上周一的
select title from info
where DATEDIFF(DD,DATEADD(DW,-6-DATEPART(DW,getdate()),getdate()),title_date)=0;
set datefirst 1
declare @d datetime;
set @d=GETDATE();
select DATEADD(DW,-6-DATEPART(DW,@d),@d);