Re: How to edit a datetime field?
| From: | John W. Holmes | Date: | Thu, 18 Mar 2004 18:24:10 +0000 |
| Subject: | Re: How to edit a datetime field? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-180875@lists.php.net to get a copy of this message | ||
From: "Brian Dunning" <brian@briandunning.com>
> 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()+7200000 which is invalid.
field = NOW() + INTERVAL 1 DAY
or
field = NOW() + INTERVAL 24 HOUR
---John Holmes...