RE: [PHP] Current date & time in MySQL datetime format
| From: | John Holmes | Date: | Sat, 22 Jun 2002 18:22:31 +0000 |
| Subject: | RE: [PHP] Current date & time in MySQL datetime format | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103409@lists.php.net to get a copy of this message | ||
Use NOW() in your query...
INSERT INTO table VALUES (NOW()),'John');
---John Holmes...
> -----Original Message-----
> From: Phil Schwarzmann [mailto:pschwar@jhmi.edu]
> Sent: Saturday, June 22, 2002 12:56 PM
> To: php-general@lists.php.net
> Subject: [PHP] Current date & time in MySQL datetime format
>
> I want to produce the current date & time in a MySQL datetime format
> that I can then put into a MySQL database.
>
> How do I do this? I've tried mktime() and getdate() but it's not
> working.
>
> Thanks!!