[PHP] How to edit a datetime field?

2004-03-18 Thread Brian Dunning
I'm trying to set a datetime field to 24 hours in the future... NOW()+6000, which worked on a timestamp field, only gives 12 seconds in the future. Algebra suggested I try NOW()+720 which is invalid. Any suggestions? Thanks! - Brian -- PHP General Mailing List (http://www.php.net/) To

Re: [PHP] How to edit a datetime field?

2004-03-18 Thread Richard Davey
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()+720 which is invalid. UPDATE table SET

Re: [PHP] How to edit a datetime field?

2004-03-18 Thread John W. Holmes
From: Brian Dunning [EMAIL PROTECTED] I'm trying to set a datetime field to 24 hours in the future... NOW()+6000, which worked on a timestamp field, only gives 12 seconds in the future. Algebra suggested I try NOW()+720 which is invalid. field = NOW() + INTERVAL 1 DAY or field =