Show the last day of month - SQL Server Date Function Last Month

--// This function is compatible >= 2008 version 

 

select EoMonth(getdate(),0)