Compare time values by using the TIMEDIFF() function: TIMEDIFF(





Compare time values by using the TIMEDIFF() function: TIMEDIFF(

   
mysql>
mysql>
mysql>
mysql> SELECT TIMEDIFF('2004-12-31 23:59:59', '2004-12-30 23:59:59');
+--------------------------------------------------------+
| TIMEDIFF('2004-12-31 23:59:59', '2004-12-30 23:59:59') |
+--------------------------------------------------------+
| 24:00:00                                               |
+--------------------------------------------------------+
1 row in set (0.00 sec)

   
    
    
  










Related examples in the same category

1.Use the function TIMEDIFF: