sql 获取当前 周一 当前月第一天等

declare @day datetime 
declare @weekA datetime 
declare @weekB datetime
declare @monthA datetime
declare @monthB datetime  
SET @day= CONVERT(varchar(100), GETDATE(), 111) 
SET @weekA=(select DATEADD(day,-(DATEPART(weekday,@day)-1),@day) ) 
SET @weekB=(select DATEADD(day,-(DATEPART(weekday,@day)-5),@day) )  
SET @monthA=( select   DATEADD(dd,-day( @day )+1, @day))
Set @monthB=(select convert(char(7),getdate(),20)+'-25 00:00:00.000')  
原文地址:https://www.cnblogs.com/genghuilove/p/6402712.html