Code: Select all
0 | 2008-06-10 15:30:01 | A
1 | 2008-06-10 15:40:01 | A // Calcute timestamp as 10 min
1 | 2008-06-10 15:50:01 |A //Skip
1 | 2008-06-10 16:00:01 |A //Skip
1 | 2008-06-10 16:10:01 |A //Skip
0 | 2008-06-10 16:20:01 |A // Calcute timestamp as 10 min
1 | 2008-06-10 16:30:01 |A
1 | 2008-06-10 16:40:01 |A //Skip
1 | 2008-06-10 16:50:01 |A //Skip
1 | 2008-06-10 17:00:01 |A //Skip
0 | 2008-06-10 17:10:01 |A
1 | 2008-06-10 17:20:01 |A //Calcute difference as 10 min
1 | 2008-06-10 17:30:01 |A
0 | 2008-06-10 17:40:01 |A
0 | 2008-06-10 17:50:01 |A //Clauculate as 20 minThe fields are Status, imestamp and Name.
As in the above example
It should display In the table the
Name| Start Time | End Time | Difference
A | 2008-06-10 15:30:01 |2008-06-10 15:40:01 | 10
A | 2008-06-10 16:10:01 | 2008-06-10 16:20:01 | 10
Based on the status 0 timestamp difference has to be calculated and if status is 1 then skip the row.
I
Please help me.