Question

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

如题！

Answer 1

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

Answer 2

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(varchar(10),DATEADD(dd, (8-CASE when datepart(weekday,'2018-02-25') = 1 Then 8 ELSE datepart(weekday,'2018-02-25')END), '2018-02-25'),120)as "最后一天(周日)"

Answer 3

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

Answer 4

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

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

Answer 5

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

-------------------------
第一天（周一） 最后一天（周日）
---------- ----------
2009-07-20 2009-07-26

(1 row(s) affected)