Oracle NEXT_DAY

Posted on 11.16.2011 by admin

Function Description

Function NEXT_DAY returns the date of the first weekday named by char that is later than the date.

Examples

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
This entry was posted in Oracle SQL Functions. Bookmark the permalink.