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.
