ADDTIME() works similar to ADDDATE() only you can add time as well.

Example

SELECT ADDTIME('208-01-02 23:59:59.999999','1 1:1:1.000002')

Returns

2008-01-02 01:01:01.000001