Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Blog 

Time Difference Calculation (amended v2)

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 15, rows affected: 27, absolute service time: 0,16 sec 
edit mode |  history  | discussion
   productid action (No column name) diff
1 A action 1 11.01.2018 17:24:00 NULL
2 A action 2 17.01.2018 16:41:00 6
3 A action 3 18.01.2018 11:12:00 1
4 A action 4 18.01.2018 11:13:00 0
5 A action 5 25.01.2018 14:44:00 7
6 B action 1 11.01.2018 17:24:00 -14
7 B action 2 17.01.2018 16:41:00 6
8 B action 3 18.01.2018 11:12:00 1
9 B action 4 18.01.2018 11:13:00 0
10 B action 5 25.01.2018 14:44:00 7
11 C action 1 11.01.2018 17:24:00 -14
12 C action 2 17.01.2018 16:41:00 6
13 C action 3 18.01.2018 11:12:00 1
14 C action 4 18.01.2018 11:13:00 0
15 C action 5 26.01.2018 14:44:00 8