getimedifferences in resultset

[chsanthosh]

Time Code
08:37:31 0
10:00:43 10
10:12:58 0
10:59:22 10
11:09:39 0
13:05:53 10
13:34:08 0
14:48:48 10
14:50:37 0
15:06:02 10
15:06:17 0
15:27:27 10
15:35:50 0
16:29:53 10
16:41:04 0
17:28:25 10

the above are myrecords ,
In that need to calculate the time differences when the Code is in 10 and 0 Order.

Can you please help me out.

Thanks

[oraclable]

Not too clear ...

give a case and an exple of calculation.

all the code are 0 or 10....

[iferianto]

##split that data into two view within condition 0 and 10

create view1 as select time,code from xxx where code=0 order by time asc;
create view2 as select time,code from xxx where code=10
by time asc;1

##then select from two view to make calculatiom

select TIMEDIFF(view1.time,view2.time) as diffab from
view1,view2;

Time Code
08:37:31 0
10:00:43 10
10:12:58 0
10:59:22 10
11:09:39 0
13:05:53 10
13:34:08 0
14:48:48 10
14:50:37 0
15:06:02 10
15:06:17 0
15:27:27 10
15:35:50 0
16:29:53 10
16:41:04 0
17:28:25 10

the above are myrecords ,
In that need to calculate the time differences when the Code is in 10 and 0 Order.

Can you please help me out.

Thanks