RE: Does MySQL require patch for Daylight Savings Time 2007 change

[Jerry Schwartz]

root@host [~]# zdump -v /etc/localtime |grep 2007
/etc/localtime  Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST
isdst=0 gmtoff=-18000
/etc/localtime  Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT
isdst=1 gmtoff=-14400
/etc/localtime  Sun Nov  4 05:59:59 2007 UTC = Sun Nov  4 01:59:59 2007 EDT
isdst=1 gmtoff=-14400
/etc/localtime  Sun Nov  4 06:00:00 2007 UTC = Sun Nov  4 01:00:00 2007 EST
isdst=0 gmtoff=-18000


Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]


> -----Original Message-----
> From: Jean-Sebastien Pilon [mailto:jspilon@stripped]
> Sent: Wednesday, February 28, 2007 2:37 PM
> To: Jerry Schwartz; mysql@stripped
> Subject: RE: Does MySQL require patch for Daylight Savings
> Time 2007 change
>
> You ran your zdump -v against this file ?
>
>
> > -----Original Message-----
> > From: Jerry Schwartz [mailto:jschwartz@stripped]
> > Sent: Wednesday, February 28, 2007 1:41 PM
> > To: Jean-Sebastien Pilon; mysql@stripped
> > Subject: RE: Does MySQL require patch for Daylight Savings
> > Time 2007 change
> >
> > As for me, /etc/localtime -> /usr/share/zoneinfo/EST5DST
> >
> > Which should be correct for my system as I am located in that
> > time zone. I
> > don't understand why MySQL doesn't give the same UNIX_TIMESTAMP for
> > "2007-03-11 02:00:00" and "2007-03-11 03:00:00". Just to make
> > sure, I tried
> > it with one minute earlier and one minute later and got the
> > same results.
> >
> > Regards,
> >
> > Jerry Schwartz
> > Global Information Incorporated
> > 195 Farmington Ave.
> > Farmington, CT 06032
> >
> > 860.674.8796 / FAX: [phone]
> >
> >
> > > -----Original Message-----
> > > From: Jean-Sebastien Pilon [mailto:jspilon@stripped]
> > > Sent: Wednesday, February 28, 2007 12:53 PM
> > > To: mysql@stripped
> > > Subject: RE: Does MySQL require patch for Daylight Savings
> > > Time 2007 change
> > >
> > > You have both compare 0100 vs 0200 and 0200 vs 0300 in my
> > > reply... It wasn't clear because of emails being wrapped at
> > 80 chars.
> > >
> > > And it still doesn't work after loading the tables with
> > > mysql_tzinfo_to_sql
> > >
> > > And /etc/localtime is a symlink to the proper tz file ?
> > >
> > > Systems Administrator
> > > Penson Financial Services Canada Inc.
> > > % Tel.: [phone] #269
> > > % Cell: 514.771.0365
> NOTICE: This email contains privileged and confidential
> information and is intended only for the individual to whom
> it is addressed. If you are not the named addressee, you
> should not disseminate, distribute or copy this e-mail.
> Please notify the sender immediately by e-mail if you have
> received this transmission by mistake and delete this
> communication from your system. E-mail transmission cannot be
> guaranteed to be secured or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or
> incomplete, or contain viruses.
>
> toute diffusion, distribution ou reproduction de cette
>