Interval value expressions : INTERVAL « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> DECLARE
  2     A INTERVAL YEAR TO MONTH;
  3     B INTERVAL YEAR TO MONTH;
  4     C INTERVAL DAY TO SECOND;
  5     D INTERVAL DAY TO SECOND;
  6  BEGIN
  7     A := INTERVAL '40-3' YEAR TO MONTH;
  8     B := INTERVAL '40' YEAR;
  9
 10  END;
 11  /

PL/SQL procedure successfully completed.

SQL>








21.8.INTERVAL
21.8.1.INTERVAL includes two datatypes that allow you to set appropriate durations more precisely
21.8.2.Interval value expressions
21.8.3.DAY TO SECOND examples
21.8.4.workarounds for defining intervals
21.8.5.Add some years and months
21.8.6.Add some days, hours, minutes, and seconds
21.8.7.Add 1 year, 2 months, 3 days, 4 hours, 5 minutes, 6.7 seconds
21.8.8.Adding and subtracting intervals
21.8.9.Interval multiplication
21.8.10.length of service for INTERVAL YEAR TO MONTH
21.8.11.Show some interval division
21.8.12.Storing elapsed time with INTERVAL DAY TO SECOND
21.8.13.Use INTERVAL types
21.8.14.Add date interval to timestamp
21.8.15.Double the interval