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 & 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
