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
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
Also refer:
http://www.itdeveloperzone.com/2015/10/eomonth-last-day-of-month-in-sql-server.html