The default timestamp display format changed between mysql 4.0 and 4.1 The easy fix is to add + 0 to all timestamp fields in selects. Like this: select my_ts + 0 from t;
You should always read the upgrade notes in the manual. This is very well documented: http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Jeff Hinds wrote:
After I upgraded from 4.0.16 to 4.1.11 I have found that the date fields are being pre-formatted and are causing problems to back-ground programs. Is there a configuration or session setting that will force the date formatting to the standard in 4.0 and earlier to correct the program issues?
Thanks,
<http://www.mtsu.edu/~itd> Information Technology Division
Jeff Hinds, ocp
Database Specialist
Middle Tennessee State University
001 Cope Administration Building
Murfreesboro, TN 37132
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
tel: fax:
(615) 898-5719
(615) 898-5720
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
