Mega Code Archive

 

Categories / MySQL / Date Time

 

ADDDATE(2005-12-31, INTERVAL 3

mysql> mysql> select ADDDATE('2005-12-31', INTERVAL '3:30' HOUR_MINUTE); +----------------------------------------------------+ | ADDDATE('2005-12-31', INTERVAL '3:30' HOUR_MINUTE) | +----------------------------------------------------+ | 2005-12-31 03:30:00                                | +----------------------------------------------------+ 1 row in set (0.00 sec) mysql>