Using Date Arithmetic : Date Arithmetic « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. Date Arithmetic

You can use the addition and subtraction operators with date type value.

You can add a number, representing a number of days, to a date.

The following example adds 2 days to July 31, 2003, and displays the resulting date:

SQL> SELECT TO_DATE('31-JUL-2003') + 2 FROM dual;

TO_DATE('
---------
02-AUG-03

SQL>