Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Subtract one date from another, yielding the number of days between the two dates
The following example subtracts July 31, 2003,  from August 2, 2003:
SQL> SELECT TO_DATE('02-AUG-2003') - TO_DATE('31-JUL-2003') FROM dual;
TO_DATE('02-AUG-2003')-TO_DATE('31-JUL-2003')
---------------------------------------------
                                            2
SQL>