Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NEXT_DAY function

The NEXT_DAY function returns the date of the day of the week following a particular date. "day of the week" is expressed as the day written out (like Monday, Tuesday, etc.). SQL> SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday') FROM dual; NEXT_DAY( --------- 18-SEP-06