weixin_43714213的博客

select DATALENGTH('66666')返回结果：5

--当前日期select getdate() CurrentDate;--当月第一天select dateadd(day,-day(getdate())+1,getdate()) current_Month_FirstDay;--当月最后一天select dateadd(month,datediff(month,0,dateadd(month,1,getdate())),-1) current_Month_EndDay; --当年第一天select dateadd(YEAR,datedi...