Date Timestamp Functions Oracle PLSQL Tutorial

SQL>
SQL> SELECT TO_DATE('02-AUG-2003') - 2 FROM dual;
TO_DATE('
---------
31-JUL-03
SQL>