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 
edit 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






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development