In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End of Month) which is used to find or get the last day of a month in a specified date.
In prior versions of SQL Server 2012, date functions like “dateadd” and/or “datediff” were invaluable in finding the last day of a month.
Consider a SQL Server 2005/2008 R2 example of how we find the last day of a month;
The use of the date functions in the example above returns a date value of 2012-08-31 00:00:00.000 (see red arrow).
Now this same result can be achieved by using the EOMONTH function in SQL Server 2012 as shown below;
DECLARE @date DATETIME
SET @date = ‘20120802’
SELECT EOMONTH (@date) AS LAST_DAY_OF _MONTH
This returns ‘2012-02-31’
Thanks for reading and hope you’ve gained something.
For additional reading, please see http://msdn.microsoft.com/en-us/library/hh213020.aspx