adding 2 hours to now()??

in my MySql database i have a field "created_at" = now()
for ex: 2011-05-23 11:47:28

i need to add two hours to that so i have 2011-05-23 13:47:28
how will i do this please?

i have this so far but it is not correct:

$currentTime = time($msg->getCreatedAt()); 
$timeAfterOneHour = $currentTime+60*60;
$date=date("Y-m-d H:i:s",$timeAfterOneHour);

please help
thank you

Greetings, you need to use the function date_add if you want to do this as easy as possible.

So instead of NOW() use this:

DATE_ADD(NOW(), INTERVAL 2 HOUR)

You could also just write:

NOW() + INTERVAL 2 HOUR

instead.