MySQL Forums
Forum List  »  General

Re: Does Change in Daylight Savings Time affect MySQL
Posted by: Matthew Boehm
Date: March 27, 2007 10:15AM

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$$!

Options: ReplyQuote




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.