SQL中取本周一的日期，最简单的方法？？？？？？？？

Question

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

Answer 1

select dateadd(dd,1-datepart(dw,getdate()),getdate())

Answer 2

select convert(varchar(8), dateadd(day, 2 - datepart(weekday, getdate()), getdate()), 112)
select convert(varchar(10), dateadd(day, 2 - datepart(weekday, getdate()), getdate()), 120)

Answer 3

select convert(varchar(10),dateadd(day,2-datepart(weekday,getdate()),getdate()),120)

Answer 4

以上是当若@@DATEFIRST为7时有效

Answer 5

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