select date '1997-08-11' - interval '3' month as col_3 : Date Arithmetic « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. Date Arithmetic
SQL>
SQL>
SQL> select date '1997-08-11' - interval '3' month as col_3
  2  from   dual;

COL_3
---------
11-MAY-97

SQL>








13.26.Date Arithmetic
13.26.1.Using Date Arithmetic
13.26.2.Subtracts two days from August 2, 2003
13.26.3.Subtract one date from another, yielding the number of days between the two dates.
13.26.4.select date '1996-01-29' + interval '1' month as col_1
13.26.5.select date '1997-08-11' - interval '3' month as col_3
13.26.6.Second Tuesday of the Month