Get first day, last day in SQL Server

Get the first and last day of a known year

1. The first day of one months

SELECT DATEADD DATEDIFF (MM,0,getdate0

2. This week's Monday

SELECT DATEADD DATEDIFF (wk,0,getdate0)

3. The first day of the year

SELECT DATEADD DATEDIFF (yy,0,getdate0)

4. First day of the quarter

SELECT DATEADD DATEDIFF (QQ,0,getdate0)

5. The night of the day

SELECT DATEADD DATEDIFF (DD,0,getdate0)

6. Last day of last month

SELECT DateAdd (MS,-3,DATEADDDATEDIFF(mm,0,getdate0

7. Last day of last year

SELECT DateAdd (MS,-3,DATEADDDATEDIFF(yy,0,getdate0

8. Last day of the month

SELECT DateAdd (MS,-3,DATEADDDATEDIFF(M,0,getdate())+1  0))

9. Last day of the year

SELECT DateAdd (MS,-3,DATEADDDATEDIFF(yy,0,getdate())+1  0

10. First Monday of the month

Select DATEADD DATEDIFF (wk,0,dateadd(DD,6-datepart(Day,getdate()), getdate 0)