Some useful dates for MS SQL SERVER

1. The first day of one months
SELECT DATEADD (mm, DATEDIFF (Mm,0,getdate ()), 0)

2. Monday of this week
SELECT DATEADD (wk, DATEDIFF (Wk,0,getdate ()), 0)

3. The first day of the year
SELECT DATEADD (yy, DATEDIFF (Yy,0,getdate ()), 0)

4. First day of the quarter
SELECT DATEADD (QQ, DATEDIFF (Qq,0,getdate ()), 0)

5. The middle of the day
SELECT DATEADD (DD, DATEDIFF (Dd,0,getdate ()), 0)

6. Last day of last month
SELECT DateAdd (Ms,-3,dateadd (mm, DATEDIFF (Mm,0,getdate ()), 0))

7. Last day of last year
SELECT DateAdd (Ms,-3,dateadd (yy, DATEDIFF (Yy,0,getdate ()), 0))

8. Last day of the month
SELECT DateAdd (Ms,-3,dateadd (mm, DATEDIFF (M,0,getdate ()) +1, 0))

9. The last day of the year
SELECT DateAdd (Ms,-3,dateadd (yy, DATEDIFF (Yy,0,getdate ()) +1, 0 )

10. The first Monday of this month
Select DATEADD (wk, DATEDIFF (Wk,0,dateadd Dd,6-datepart (Day,getdate ()), GETDATE ()), 0)