[EMAIL PROTECTED] [~]# 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: 860.674.8341 > -----Original Message----- > From: Jean-Sebastien Pilon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 28, 2007 2:37 PM > To: Jerry Schwartz; mysql@lists.mysql.com > 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:[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 nest 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 > lexpé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 derreur puisque les informations > quil 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]
