sql server 2008 first and last day of month
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) ----First Day SELECT DATEADD (dd, -1, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 0)) ----Last Day
Source: stackoverflow.com
SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0) ----First Day SELECT DATEADD (dd, -1, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 0)) ----Last Day