Re: DB / tablevalues / query 'now()'
| From: | Justin Patrin | Date: | Sat, 18 Dec 2004 18:35:09 +0000 |
| Subject: | Re: DB / tablevalues / query 'now()' | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16312@lists.php.net to get a copy of this message | ||
On Sat, 18 Dec 2004 16:05:03 +0100, Stephan Heller [daik.de]
<heller@daik.de> wrote:
> Hi List,
>
> I'm looking for a possibility to insert a datetime-Value comparable to
> 'now()' in MySql
>
> using 'autoPrepare' and 'execute'
>
> Now() doesn't work by using this methods
>
> How does it work?
>
Well, you could use a timestamp, which is auto-updated whenever the
record is updated.
You could also use date('Y-m-d H:i:s').
--
Justin Patrin