Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

How i can get the difference of closest two date in two table join in ...

Language: Layout:
absolute service time: 0,77 sec 
fork mode |  history  | discussion
   activity_timestamp activity diff seconds minutes
1 23.12.2016 13:54:47 reading 00:01:00 60 1
2 24.12.2016 21:12:56 reading 00:03:00 180 3
3 27.12.2016 16:10:39 reading 00:04:00 240 4
4 09.01.2017 14:17:52 reading 00:02:00 120 2