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
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
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 =
3 matches
Mail list logo