Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>