| 13. 26. 1. Using 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>
|
|