Example: Querying for DATE for the Last Day of the Month
The following query:
SELECT LAST_DAY(DATE '2009-12-20');
returns the result 2009/12/31.
Example: Querying for TIMESTAMP for the Last Day of the Month
The following query:
SELECT LAST_DAY(TIMESTAMP '2009-08-25 10:14:59');
returns the result 2009/08/31.
Example: Querying for TIMESTAMP WITH TIME ZONE for the Last Day of the Month
The following query:
SELECT LAST_DAY(TIMESTAMP '2009-06-15 10:14:59-8:00');
returns the result 2009/06/30.