Same exact issue on v5.0.27. I installed another windows patch, that did nothing, but then changed my system clock to march 12th, and then back to present day. Now the DST shifts are correct in the future and incorrect in the past. I've destroyed the timezone tables, and they made no difference. Which means that they were never being used.
Any ideas? ----- Original Message ----- From: "Bryan S. Katz" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, February 20, 2007 7:50 PM Subject: MySQL Daylight Savings Time Patch > Running 4.1.22, on windows 98, I'm having trouble getting the time zone > tables to actually work. I've loaded the tables as per: > http://dev.mysql.com/downloads/timezones.html, and followed the diagnostics > as per: http://lists.mysql.com/mysql/205115 > . > > It appears that my results from said diagnostic indeed prove that my tables > are correct. However, I don't see those tables being used. The following > statements yield varying results on my linux/windows machines (I run about > ten servers). > > SELECT DATE_FORMAT(from_unixtime(unix_timestamp('2007-4-1 00:00:00') + > 2*60*60),'%H'); > SELECT DATE_FORMAT(from_unixtime(unix_timestamp('2007-3-11 00:00:00') + > 2*60*60),'%H'); > SELECT DATE_FORMAT(from_unixtime(unix_timestamp('2006-4-2 00:00:00') + > 2*60*60),'%H'); > SELECT DATE_FORMAT(from_unixtime(unix_timestamp('2006-3-12 00:00:00') + > 2*60*60),'%H'); > > The linux machine -- with empty timezone tables is correct. 2007-3-11 and > 2006-4-2 result in midnight plus 2 hours being 3am -- correct in the past > and correct in the future. On my modern XP machines, the future is correct > and the past is incorrect. On my older XP/98 machines, the past is correct > and the future is incorrect. It is on my 98 server that I am now playing, > having loaded timezone tables, and going crazy. I have upgraded my win98 > timezones via a registry update. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]