Eomonth Function comes with SQL Server 2012. This function is used to get last date of the month with given date.
Syntax:
Eomonth (date)
Example:
Select Eomonth(Getdate()) as LastDateOfMonth
Result:
2015-06-30
What is Eomonth Function in SQL Server?
Posted on June 5th, 2015 by Hitesh Kumar | 254 Views
Also refer:
http://www.itdeveloperzone.com/2015/10/eomonth-last-day-of-month-in-sql-server.html