Posted by meltedown on 11/16/06 11:28

meltedown wrote:
> In this statement:
> "INSERT INTO logins(accountid,userid,login,jobdesc)
> values($preaccountid,$userid,NOW(),'$jobdesc')")
>
> How do I add an hour to NOW() ?
> I tried NOW+60*60, but it adds 37 minutes, which makes no sense at all.
I found a web page that explained it
http://www.phpbuilder.com/board/showthread.php?s=3f858548616c63364dbe776e3f791cce&threadid=10240031&goto=nextoldest

"INSERT INTO logins(accountid,userid,login,jobdesc)
values($preaccountid,$userid,adddate(NOW(),interval 1 hour),'$jobdesc')");

[Back to original message]