RE: [PHP] Current date & time in MySQL datetime format

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 > To: [EMAIL PROTECTED] > Subject: [PHP] Current date &

Re: [PHP] Current date & time in MySQL datetime format

Use the date() function. On Sat, 22 Jun 2002, Phil Schwarzmann wrote: > 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 Gene

[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!!