SQL Server 之 DateTime的常用方法
1.取当月月初时间
--取月初 SELECT dateadd(day,-day(getdate())+1,convert(VARCHAR,GETDATE(),111))
2.取当月月末时间
--取月末 SELECT dateadd(day,-day(getdate()),dateadd(month,1,convert(VARCHAR,getdate(),111)))
--取月初 SELECT dateadd(day,-day(getdate())+1,convert(VARCHAR,GETDATE(),111))
--取月末 SELECT dateadd(day,-day(getdate()),dateadd(month,1,convert(VARCHAR,getdate(),111)))