//月初
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-05-31 10:14:49 发布
//月初
select convert(varchar(10),dateadd(dd,-datepart(dd,getdate())+1,getdate()) ,23)
//月末
select convert(varchar,dateadd(day,-day(getdate()),dateadd(month,1,getdate())),23)