Hello All,
I am struggling to covert the RUN_TIME column to get the difference of time between each steps.
Please help me out to get the output.
Output expected:
DIFF_IN_SEC should get the duration of steps like step-4 has taken 19 sec to reach from step 3 to 4. (like LEAD)
Demo Script:
Table: RUN_TIME mentioned as varchar2 and default is SYSTIMESTAMP that's the main issue in conversion and i don't have any option to change the table definition.
Create table step_details(
SID number,
Steps varchar2(500),
run_time VARCHAR2(500) DEFAULT systimestamp);
Dummy Data:
insert into step_details values (1,'Step-1','21.01.20 11:00:15,870832 +02:00' );
insert into step_details values (2,'Step-2','21.01.20 11:00:15,873361 +02:00' );
insert into step_details values (3,'Step-3','21.01.20 11:00:15,887883 +02:00' );
insert into step_details values (4,'Step-4','21.01.20 11:00:34,441789 +02:00' );
insert into step_details values (5,'Step-5','21.01.20 11:00:54,842630 +02:00' );
insert into step_details values (6,'Step-6','21.01.20 11:00:54,843515 +02:00' );
insert into step_details values (7,'Step-7','21.01.20 11:00:58,643928 +02:00' );
insert into step_details values (8,'Step-8','21.01.20 11:00:59,600611 +02:00' );
insert into step_details values (9,'Step-9','21.01.20 11:02:31,647588 +02:00' );
insert into step_details values (10,'Step-10','21.01.20 11:02:37,919589 +02:00' );
insert into step_details values (11,'Step-11','21.01.20 11:02:37,923015 +02:00' );
Thanks