Function Description
Function NEXT_DAY returns the date of the first weekday named by char that is later than the date.
Examples
|
1 2 3 4 5 6 7 8 9 |
SELECT NEXT_DAY('02.11.2011','FRIDAY') AS "NEXT DAY" FROM dual; Result: 4.11.2011 SELECT NEXT_DAY('30.11.2011','FRIDAY') AS "NEXT DAY" FROM dual; Result: 2.12.2011 |