Aren't the time zone tables new in 4.1.3?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: Bryan S. Katz [mailto:bskatz@stripped]
> Sent: Tuesday, February 20, 2007 9:03 PM
> To: mysql@stripped
> Subject: Re: MySQL Daylight Savings Time Patch
>
> 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" <bskatz@stripped>
> To: <mysql@stripped>
> 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/mysql?unsub=1
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
