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: upgrading from mysql 4.0 to 4.1 : TIMESTAMP OTHER FEATURES

2006-12-20 Thread Dan Buettner
Regarding the format of TIMESTAMP columns, one of the user comments on http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html offers the solution below: Posted by Kjell Arne Rekaa on April 14 2005 11:11pm If you want the same view of a timestamp field in 4.1.x as it was in in earlier mysql