Date Timestamp Functions Oracle PLSQL Tutorial

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>