LAST_DAY
Returns the last day of the month in the specified date.
Behavior Type
Syntax
LAST_DAY ( date )
Parameters
date |
The date to process, one of the following data types: |
Examples
The following example returns the last day of February as 29 because 2016 is a leap year:
=> SELECT LAST_DAY('2016-02-28 23:30 PST') "Last Day"; Last Day ------------ 2016-02-29 (1 row)
The following example returns the last day of February in a non-leap year:
> SELECT LAST_DAY('2017/02/03') "Last"; Last ------------ 2017-02-28 (1 row)
The following example returns the last day of March, after converting the string value to the specified DATE type:
=> SELECT LAST_DAY('2003/03/15') "Last"; Last ------------ 2012-03-31 (1 row)