Hello Brian, Thursday, March 18, 2004, 4:10:20 PM, you wrote:
BD> I'm trying to set a datetime field to 24 hours in the future... BD> NOW()+6000, which worked on a timestamp field, only gives 12 seconds in BD> the future. Algebra suggested I try NOW()+7200000 which is invalid. UPDATE table SET datefield = DATE_ADD(now(), INTERVAL 24 hour) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php