end month sql code example
Example 1: sql end of month
EOMONTH(start_date [, offset] );
Example 2: mssql last day of month
SELECT DATEADD(month, ((YEAR(getdate()) - 1900) * 12) + MONTH(getdate()), -1)
EOMONTH(start_date [, offset] );
SELECT DATEADD(month, ((YEAR(getdate()) - 1900) * 12) + MONTH(getdate()), -1)