Posted by Rik on 06/21/07 07:37

On Thu, 21 Jun 2007 02:17:08 +0200, mantrid <ian.dandav@virgin.net> wrote:

> That did it. thanks.
> Just one problem with the field datetime (type datetime). values are not
> saving, get 0000-00-00 00:00:00 added instead of the actual date and
> time.

That is what happens if MySQL gets a string it cannot interpret as a
datetime field. Check the format of the date you have in the file, and
adjust it before inserting to MySQL's format.

--
Rik Wasmus

[Back to original message]