Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>