![]() Previous |
![]() Next |
NEXT_DAY
returns the date of the first instance of a particular day of the week that follows the specified date.
Return Value
DATE
Syntax
NEXT_DAY(date, char)
Arguments
date
is a datetime expression.
char
is a text expression that identifies a day of the week (for example, Monday) in the language of your session.
Example
NEXT_DAY('11-SEP-01', 'Monday')
returns the value 17-SEP-01
.