Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Select date 1997-08-11 - interval 3 month as col_3
SQL>
SQL> select date '1997-08-11' - interval '3' month as col_3
  2  from   dual;
COL_3
---------
11-MAY-97
SQL>