SEO

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.

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@HolophrasticEnterprises.com>
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/mysql?unsub=m...nterprises.com
>

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@HolophrasticEnterprises.com]
> Sent: Tuesday, February 20, 2007 9:03 PM
> To: mysql@lists.mysql.com
> 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@HolophrasticEnterprises.com>
> 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/mysql?unsub=m...nterprises.com
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=j...e-infoshop.com
>
>

Yes they are; and 22 >= 3

----- Original Message -----
From: "Jerry Schwartz" <jschwartz@the-infoshop.com>
To: "'Bryan S. Katz'" <bskatz@HolophrasticEnterprises.com>;
<mysql@lists.mysql.com>
Sent: Wednesday, February 21, 2007 10:30 AM
Subject: RE: MySQL Daylight Savings Time Patch


> 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@HolophrasticEnterprises.com]
> > Sent: Tuesday, February 20, 2007 9:03 PM
> > To: mysql@lists.mysql.com
> > 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@HolophrasticEnterprises.com>
> > 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/mysql?unsub=m...nterprises.com
> > >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=j...e-infoshop.com
> >
> >
>
>
>