Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NEXT_DAY(x, day)

You specify day as a literal string, such as SATURDAY. Displays the date of the next Saturday after January 1, 2005: SQL> SELECT NEXT_DAY('01-JAN-2005', 'SATURDAY') FROM dual; NEXT_DAY( --------- 08-JAN-05 SQL>