Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Compare time values by using the TIMEDIFF() function
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)