RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to TIMESTAMP

[Taco Fleur]

 
Hi thanks for replying.
I can't immediately see the difference between your sample and mine, except
the single quotes are missing, is that it?
Thanks in advance.
-----Original Message-----
From: tere [mailto:tfinez@stripped] 
Sent: Monday, 22 January 2007 9:12 PM
To: mysql@stripped
Subject: RE: Cannot convert value '0000-00-00 00:00:00' from column 4 to
TIMESTAMP

This is because with version 4.1 and higher the format of timestamp changes
to 0000-00-00 00:00:00. We had this problem, so we had to add a few lines in
the scripts that take this field and work with it

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1