查询出下周一17:00的SQL语句

Question

结果为：2012-04-23 17:00:00

Answer 1

select dateadd(d,(9-DATEPART(dw,getdate())),getdate())

Answer 2

select dateadd(dd,8-(datepart(dw,getdate())-1),getdate())
                                            每周的开始,为周一
--2012-04-23 13:54:59.957

Answer 3

select convert(varchar(10),dateadd(dd,8-(datepart(dw,getdate())-1),getdate()),120) +' 17:00:00'
                                            每周的开始,为周一
---------------------2012-04-23 17:00:00