Re: Does Change in Daylight Savings Time affect MySQL
Apparently, downloading and installing the newest tzdata from
http://www.twinsun.com/tz/tz-link.htm is not the same as the RPM package from RedHat.
After installing the tzdata package from RedHat (using up2date) and then re-importing the zone info into mysql (via mysql_tzinfo_to_sql) and then restarting all mysql servers, my CONVERT_TZ above now shows correctly.
what a major pain in the a$$!
Subject
Written By
Posted
February 02, 2007 01:48PM
Re: Does Change in Daylight Savings Time affect MySQL
March 27, 2007 10:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.