What does the Oracle last_day function do?

The Oracle LAST_DAY function returns the last day of the month for a specified date. It takes a date as a parameter and returns the date of the last day of the month that date falls in. For example, if the input date is ‘2022-09-15’, the LAST_DAY function will return ‘2022-09-30’. This function is commonly used in SQL queries to retrieve the last day of the month for a given date.