SELECT CONVERT(varchar(10), GETDATE(), 111)
select CONVERT(varchar(6) ,getdate(),112)
SELECT CONVERT(varchar(6),dateadd(year, datediff(year, 0, getdate()), 0),112)
SELECT CONVERT(varchar(6),DATEADD(m,1 ,dateadd(dd,-day(getdate())+1,getdate())) ,112)
SELECT CONVERT(varchar(100), GETDATE(), 111)
select CONVERT(varchar(10),dateadd(dd,-day(getdate())+1,getdate()),111) --月第一天
select CONVERT(DATE ,dateadd(dd,-day(getdate())+1,getdate()),111) --月第一天
SELECT CONVERT(varchar(10),dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)), 111) --月最后一天
SELECT CONVERT(DATE ,dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)), 111) --月最后一天
select CONVERT(varchar(10),dateadd(year, datediff(year, 0, getdate()), 0),111) --年第一天
select CONVERT(DATE ,dateadd(year, datediff(year, 0, getdate()), 0),111) --年第一天
select CONVERT(varchar(10),dateadd(year, da