Printable View
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
Not too clear ...
give a case and an exple of calculation.
all the code are 0 or 10....
##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;
Quote:
Originally Posted by chsanthosh