upgrading from mysql 4.0 to 4.1 : TIMESTAMP & OTHER FEATURES

2006-12-20 Thread tere
Hi! I would like to upgrade the database of my organisation from mysql4.0.22 from 4.1. We use Debian. I've read info in the manual, but i don't have things clear. We process data of DB with scripts, and I'm annoyed because the change of format of timestamp, is there any command in 4.1 to obtain

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

2007-01-22 Thread tere
This is because with version 4.1 and higher the format of timestamp changes to -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: