Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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>