Storing elapsed time with INTERVAL DAY TO SECOND : INTERVAL « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL> declare
  2      v_start_ts  TIMESTAMP:= to_timestamp('14:00:00','HH24:MI:SS');
  3      v_end_ts    TIMESTAMP:= to_timestamp('15:12:24','HH24:MI:SS');
  4      v_delta_int INTERVAL DAY TO SECOND;
  5  begin
  6     v_delta_int:=v_end_ts-v_start_ts;
  7     DBMS_OUTPUT.put_line(v_delta_int);
  8  end;
  9  /
+00 01:12:24.000000

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