Mega Code Archive

 

Categories / MySQL / Date Time

 

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>