Compare time values by using the TIMEDIFF() function: TIMEDIFF(, ) : TIMEDIFF « Date Time « SQL / MySQL

1. SQL / MySQL
2. Date Time
3. 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