Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The NEXT_DAY function returns the date of the first instance of a particular day of the week that follows the specified date.
DATETIME
NEXT_DAY(datetime-expression, weekday)
An expression that has the DATETIME data type.
A text expression that identifies a day of the week (for example, Monday). Valid names are controlled by the NLS_DATE_LANGUAGE option.
OLADM1787Example 8-35 Getting a Future Date
The following statement returns the date of the first Tuesday following today's date.
SHOW NEXT_DAY(SYSDATE, 'Tues')
When today is Friday, September 8, 2000, then the following Tuesday is
11-SEP-00