RE: [PHP-DB] Adding an DATETIME as a string to a mySQL databse... .

did you put ' ' around the value? if you want to enter the current time you can simply do now() Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -----Original Message----- From: Mattias Hedman [mailto:mattias@popwire.com] Sent: Wednesday, July 12, 2000 12:05 PM To: php-general@lists.php.net Cc: php-db@lists.php.net Subject: [PHP-DB] Adding an DATETIME as a string to a mySQL databse.... Hello all, I am having troubles adding an value to an mySQL database, the row is set as DATETIME which should accept strings. When I build the string using DATE("Y-m-d H:i:s") in PHP and inserts it into the database the only thing that gets added in the row is DATETIME default value (0000-00-00 00:00:00). Why? Please help. TIA, Greetings, Mattias Hedman -- mattias.hedman@popwire.com web programmer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net