Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Next_day(sysdate,SAT)
SQL>
SQL> select sysdate
  2  ,      next_day(sysdate,'SAT') as next_sat
  3  from   dual;
SYSDATE   NEXT_SAT
--------- ---------
24-JUL-08 26-JUL-08
SQL>