How to get the last day of date in SQL

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