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

Pekka · Accepted Answer · 2010-04-07 13:57:21Z

8

DATE_ADD() should do the job:

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

answered Apr 7, 2010 at 13:57

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.