Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Subtract from a date by using the SUBDATE() or DATE_SUB() functions
pe>)
mysql>
mysql>
mysql> SELECT SUBDATE('2004-10-31 23:59:59', INTERVAL '12:10' HOUR_MINUTE);
+--------------------------------------------------------------+
| SUBDATE('2004-10-31 23:59:59', INTERVAL '12:10' HOUR_MINUTE) |
+--------------------------------------------------------------+
| 2004-10-31 11:49:59                                          |
+--------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>