//月初
select convert(varchar(10),dateadd(dd,-datepart(dd,getdate())+1,getdate()) ,23)
//月末
select convert(varchar,dateadd(day,-day(getdate()),dateadd(month,1,getdate())),23)
sql 获取月初和月末
最新推荐文章于 2024-08-06 17:03:59 发布
//月初
select convert(varchar(10),dateadd(dd,-datepart(dd,getdate())+1,getdate()) ,23)
//月末
select convert(varchar,dateadd(day,-day(getdate()),dateadd(month,1,getdate())),23)