q51259816, MySQL - rextester

q51259816

Language: Layout:


absolute service time: 0,31 sec

edit mode | history

  
UNIX_TIMESTAMP('2015-03-29 08:21:15') - UNIX_TIMESTAMP('2015-03-27 08:21:15')

1
169200


  
TIMESTAMPDIFF(SECOND, '2015-03-27 08:21:15', '2015-03-29 08:21:15')

1
172800


  
TIMESTAMPDIFF(SECOND, '2015-03-29 08:21:15', '2015-03-27 08:21:15')

1
-172800


  
ABS(TIMESTAMPDIFF(SECOND, '2015-03-29 08:21:15', '2015-03-27 08:21:15'))

1
172800

λ

                                      .NET NoSQL database for rapid development