SQL Server 0101 首日期的处理



First day of one week

select DATEADD(wk,DATEDIFF(wk,0,@DynamicDate), 0) as CurrentWeek

 

First day of one month

select DATEADD(mm,DATEDIFF(mm,0,@DynamicDate), 0) as CurrentMonth

 

First day of one quarter

select DATEADD(qq,DATEDIFF(qq,0,@DynamicDate), 0) asCurrentQuarter

 

First day of one halfYear

Select DATEADD(qq,2,DATEADD(yy, DATEDIFF(yy,0,@DynamicDate), 0))CurrentHalfYear

 

First day of one year

select DATEADD(yy,DATEDIFF(yy,0,@DynamicDate), 0) as CurrentYear