Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
LAST_DAY
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