New Function in Sql 2012

Often in financial applications, its required to calculate End date of a month. SQL Server 2012 provides a function EOMONTH() to calculate end date of a month.

In order to ease the developer, a new function added:EOMONTH(<date>)

Sample:

select EOMONTH ( getdate() ) AS EndOfMonth;