How to update time in mysql by ADDTIME()?

Question

I have table: test and field called: id. I want update time (ex. add 2 hours) where id=1000. How to do this?

Answer 1

UPDATE test SET time = time + INTERVAL 2 HOUR WHERE id = 1000

Using ADDTIME():

UPDATE test SET time = ADDTIME(time, '02:00:00') WHERE id = 1000