Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Storing elapsed time with INTERVAL DAY TO SECOND

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>