DAY TO SECOND examples : 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     C := INTERVAL '10 1:02:10.123' DAY TO SECOND;
  8
  9  END;
 10  /

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