Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

NEXT_DAY

SQL> -- NEXT_DAY: the date of the day of the week following a particular date SQL> SQL> SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday')   2  FROM dual; NEXT_DAY( --------- 18-SEP-06 SQL>