Adding and subtracting intervals : INTERVAL « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. INTERVAL

SQL> DECLARE
  2     a1 INTERVAL DAY TO SECOND := '2 3:4:5.6';
  3     b1 INTERVAL DAY TO SECOND := '1 1:1:1.1';
  4
  5     a2 INTERVAL YEAR TO MONTH := '2-10';
  6     b2 INTERVAL YEAR TO MONTH := '1-1';
  7
  8     a3 NUMBER := 3;
  9     b3 NUMBER := 1;
 10  BEGIN
 11     DBMS_OUTPUT.PUT_LINE(a1 - b1);
 12     DBMS_OUTPUT.PUT_LINE(a2 - b2);
 13     DBMS_OUTPUT.PUT_LINE(a3 - b3);
 14  END;
 15  /

PL/SQL procedure successfully completed.

SQL>
SQL>