You ran your zdump -v against this file ?

> -----Original Message-----
> From: Jerry Schwartz [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, February 28, 2007 1:41 PM
> To: Jean-Sebastien Pilon; mysql@lists.mysql.com
> 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: 860.674.8341
> 
> 
> > -----Original Message-----
> > From: Jean-Sebastien Pilon [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 28, 2007 12:53 PM
> > To: mysql@lists.mysql.com
> > 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 ?
> >
> > Jean-Sébastien Pilon
> > Systems Administrator
> > Penson Financial Services Canada Inc.
> > % Tel.: 514.841.9724 #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. 

AVIS: Le présent courriel contient des renseignements de nature privilégiée et 
confidentielle et n’est destiné qu'à la personne à qui il est adressé. Si vous 
n’êtes pas le destinataire prévu, vous êtes par les présentes avisés que toute 
diffusion, distribution ou reproduction de cette communication est strictement 
interdite.  Si vous avez reçu ce courriel par erreur, veuillez en aviser 
immédiatement l’expéditeur et le supprimer de votre système. Notez que la 
transmission de courriel ne peut en aucun cas être considéré comme inviolable 
ou exempt d’erreur puisque les informations qu’il contient pourraient être 
interceptés, corrompues, perdues, détruites, arrivées en retard ou incomplètes 
ou contenir un virus.  

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to