| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The LAST_DAY function returns the last day of the month in which a particular date falls.
Return Value
DATETIME
Syntax
LAST_DAY(datetime-expression)
Arguments
An expression that has the DATETIME data type.
Examples
Example 8-5 Calculating Remaining Days in a Month
The following statement calculates how many days remain between today's date and the end of the month.
SHOW JOINCHARS('Days left: ' LAST_DAY(SYSDATE) - SYSDATE)
When today's date is September 8, 2000, then this statement returns the following.
Days left: 22
