首先,得到本周的星期一和星期五的日期
select dateadd(day,-datepart(weekday,getdate())+2,getdate()),dateadd(day,7-datepart(weekday,getdate())-1,getdate())
其次,得到X(X=-27)周的星期一和星期五的日期
select dateadd(week,-27,dateadd(day,-datepart(weekday,getdate())+2,getdate())), dateadd(week,-27,dateadd(day,7-datepart(weekday,getdate())-1,getdate()))
作者:敖士伟 ikmb@163.com