Sql Server 获取本周周一
程序员文章站
2022-03-13 16:36:41
SELECT DATEADD(Day,(@i+1)-(DATEPART(Weekday,getdate())+@@DATEFIRST-1)%7,getdate()) ......
select dateadd(day,(@i+1)-(datepart(weekday,getdate())+@@datefirst-1)%7,getdate())