比如说今天是:2008-11-19
语句一:
select DATEADD(Day, 1 - DATEPART(Weekday,CONVERT(varchar(10), GETDATE() - 7, 120)), CONVERT(varchar(10), GETDATE()- 7, 120))
结果是:2008-11-09 00:00:00.000
语句二:
select DATEADD(Day, 1 - DATEPART(Weekday,CONVERT(varchar(10), GETDATE() - 7, 120)), CONVERT(varchar(10), GETDATE(), 120))
结果是:2008-11-16 00:00:00.000