get last month last day

SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.