Adding an DATETIME as a string to a mySQL databse....
| From: | Mattias Hedman | Date: | Wed, 12 Jul 2000 10:04:58 +0000 |
| Subject: | Adding an DATETIME as a string to a mySQL databse.... | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-1063@lists.php.net to get a copy of this message | ||
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