[Resolved] NOW() + hours

[baffled_in_UK]

Hi,

I've not been able to find exactly what I need in other posts.

What I want to do is add a fixed number of hours to a DATETIME field when I write it to my Db.

Thanks

[bubblenut]

Right, you haven't given us a lot to go on here so I'm just going to dive in with a little bit of code (in the hope that you'll do the same) and see what you think.

$date='2004-10-12 12:34:00';
$sql="INSERT INTO table (field) VALUES (ADDTIME('$date', '5:0:0'))";n //adds 5 hours

Is that what you're after?

[xblue]

NOW() + INTERVAL x HOUR
or
DATE_ADD(NOW(), INTERVAL x HOUR)
should work

(note that even if x>1, it should be hour not hours)

[baffled_in_UK]

Thank you both.

I used NOW() + INTERVAL x HOUR and it worked perfectly.