Sql Server 当前日期第一天

--当前日期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,datediff(YEAR,0,getdate()),0) current_Year_FirstDay;--当年最后天select dateadd(YEAR,datediff(YEAR,0,dateadd(YEAR,1,getdate())),-1) current_Year_EndDay; --下年第一天select dateadd(YEAR,datediff(YEAR,0,dateadd(YEAR,1,getdate())),0) next_Year_Firstday;--下年最后一天select dateadd(YEAR,datediff(YEAR,0,dateadd(YEAR,2,getdate())),-1) next_Year_Endday;--上年第一天select dateadd(YEAR,datediff(YEAR,0,dateadd(YEAR,-1,getdate())),0) last_Year_Firstday;--上年最后一天select dateadd(YEAR,datediff(YEAR,0,getdate()),-1) last_Year_Endday;