Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Use the ADDDATE() function to add 10 hours and 20 minutes to the specified datetime value
mysql>
mysql>
mysql> SELECT ADDDATE('2004-10-31 13:39:59', INTERVAL '10:20' HOUR_MINUTE);
+--------------------------------------------------------------+
| ADDDATE('2004-10-31 13:39:59', INTERVAL '10:20' HOUR_MINUTE) |
+--------------------------------------------------------------+
| 2004-10-31 23:59:59                                          |
+--------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>