In Oracle/PLSQL, the next_day function returns the first weekday that is greater than a date.
Syntax
The syntax for the next_day function is:
next_day( date, weekday )
date is used to find the next weekday.
weekday is a day of the week (ie: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i
For Example
select next_day(current_date, 7) from dual; | |