SQL Tutorials: SQL First and Last Day Of a Month
Get Last Day of a Month Using SQL Query SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,-2,@Today)) Value = 2007-03-31 00:00:00.000 SELECT DATEADD(dd, -DAY(DATEADD(m,1,@Today)), DATEADD(m,-1,@Today)) Value = 2007-04 ......