LAST_DAY

LAST_DAY function returns the last day of the month based on a date value.

Syntax

LAST_DAY( date )

Example

SELECT LAST_DAY(TO_DATE('2020/02/03', 'yyyy/mm/dd'))

Returns:

2020-02-29