将传入的时间置为当月第一天的零点

declare @ct as datetime
select @ct=GETDATE()
print @ct
select @ct=dateadd(month,datediff(month,0,@ct), '00:00:00')
print @ct
原文地址:https://www.cnblogs.com/lthxk-yl/p/3268196.html