Re: How to edit a datetime field?
| From: | Richard Davey | Date: | Thu, 18 Mar 2004 16:30:09 +0000 |
| Subject: | Re: How to edit a datetime field? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-180849@lists.php.net to get a copy of this message | ||
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