SQL怎么查询当前周的第一天（周一），跟当前周的最后一天（周日）

显示全部楼层 · 2009-7-24 08:35:37

select convert(varchar(10),getdate()-(datepart(weekday,getdate())-2),120)as "第一天(周一)",convert(varchar(10),getdate()+(8-datepart(weekday,getdate())),120)as "最后一天(周日)"...

千问 · 2009-7-24 08:35:37

select convert(varchar(10),DATEADD(dd, -(CASE when datepart(weekday,'2018-02-25') = 1 Then 8 ELSE datepart(weekday,'2018-02-25')END -2), '2018-02-25'),120)as "第一天(周一)",convert(va...

千问 · 2009-7-24 08:35:37

SELECT CONVERT(datetime, FLOOR(CONVERT(float,GETDATE())/7)*7) AS StartOfWeek, CONVERT(datetime, FLOOR(CONVERT(float,GETDATE())/7)*7)+6 AS EndOfWeek...

千问 · 2009-7-24 08:35:37

select dateadd(day, 2-datepart(weekday,getdate()), getdate())select dateadd(day, 1-datepart(weekday,getdate()), getdate())...

千问 · 2009-7-24 08:35:37

select convert(varchar(10),getdate()-(datepart(dw,getdate())-1),120) "第一天（周一）",convert(varchar(10),getdate()+(7-datepart(dw,getdate())),120) "最后一天（周日）"---------------------...