Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Select date 1996-01-29 + interval 1 month as col_1
SQL>
SQL> select date '1996-01-29' + interval '1' month as col_1
  2  from   dual;
COL_1
---------
29-FEB-96