Use NOW() in your query...

INSERT INTO table VALUES (NOW()),'John');

---John Holmes...

> -----Original Message-----
> From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 22, 2002 12:56 PM
> 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!!

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to