Devi usare addtime.

es.
select addtime('2008-09-28 16:41:10','28:00:00') // 2008-09-29 20:41:10