Date Timestamp Functions Oracle PLSQL Tutorial

SQL>  SELECT TO_CHAR(NEXT_DAY('01-SEP-99','Monday'),'MM/DD/YYYY HH:MM:SS AM')
  2       "Next_Day"
  3   from DUAL;
Next_Day
----------------------
09/06/1999 12:09:00 AM
SQL>