Returns the date of the last day of the month for each date in a column.

Date. The last day of the month for that date value you pass to this function.

NULL if a value in the selected column is NULL.

If a value is NULL, LAST_DAY ignores the row. However, if all values passed from the column are NULL, LAST_DAY returns NULL.

The following expression returns the last day of the month for each date in the ORDER_DATE column:

You can nest TO_DATE to convert string values to a date. TO_DATE always includes time information. If you pass a string that does not have a time value, the date returned will include the time 00:00:00.

The following example returns the last day of the month for each order date in the same format as the string: