problem with date() function

Question

i save in mysql database the time using NOW() function. how can i change the value returned of NOW() function? i want to add 6 hours.

example

if now() returns 2010-04-03 20:16:27, i want to save 2010-04-04 02:16:27

Answer 1

DATE_ADD() should do the job:

INSERT INTO ...... DATE_ADD(NOW(), INTERVAL 6 HOUR);