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
>
> > -----Original Message-----
> > From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 28, 2007 12:13 PM
> > To: Jean-Sebastien Pilon; 'Causevic, Dzenan'; mysql@lists.mysql.com
> > Subject: RE: Does MySQL require patch for Daylight Savings
> > Time 2007 change
> >
> > Hang on a second! Doesn't EST transition to DST at 03:00?
> > Shouldn't that
> > query (the one for testing MySQL's time zones) be
> >
> > SELECT UNIX_TIMESTAMP('2007-03-11
> > 02:00:00'),UNIX_TIMESTAMP('2007-03-11
> > 03:00:00');
> >
> > ? Nonetheless, it doesn't work for me. I get a one-hour
> > difference, just as
> > though the DST transition never existed. My time_zone
> > variable is set to
> > SYSTEM, and I've verified using zdump (Linux) that the time
> > zone tables on
> > my server are correct. I have loaded the latest time zone
> > information using
> >
> > mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
> >
> > although it gave me some errors about Riyadh.
> >
> > 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 10:55 AM
> > > To: Causevic, Dzenan; mysql@lists.mysql.com
> > > Subject: RE: Does MySQL require patch for Daylight Savings
> > > Time 2007 change
> > >
> > > I don't believe so, since the version of MySQL you are
> > using relies on
> > > the system's time. I am using 4.1 and I am setup to use
> > system's time
> > > and my timezone tables in the mysql schema are empty. I
> would take a
> > > look at those on your installation. You can also run the
> 2nd command
> > > below to see if the system returns proper time, both unix
> timestamp
> > > should be equal...
> > >
> > > mysql> SHOW VARIABLES LIKE 'time_zone';
> > > +---------------+--------+
> > > | Variable_name | Value  |
> > > +---------------+--------+
> > > | time_zone     | SYSTEM |
> > > +---------------+--------+
> > > 1 row in set (0.00 sec)
> > >
> > >
> > > mysql> SELECT UNIX_TIMESTAMP('2007-03-11
> > > 01:00:00'),UNIX_TIMESTAMP('2007-03-11 02:00:00');
> > > +---------------------------------------+---------------------
> > > ----------
> > > --------+
> > > | UNIX_TIMESTAMP('2007-03-11 01:00:00') |
> UNIX_TIMESTAMP('2007-03-11
> > > 02:00:00') |
> > > +---------------------------------------+---------------------
> > > ----------
> > > --------+
> > > |                            1173592800 |
> > > 1173596400 |
> > > +---------------------------------------+---------------------
> > > ----------
> > > --------+
> > > 1 row in set (0.00 sec)
> > >
> > > mysql> SELECT UNIX_TIMESTAMP('2007-03-11
> > > 02:00:00'),UNIX_TIMESTAMP('2007-03-11 03:00:00');
> > > +---------------------------------------+---------------------
> > > ----------
> > > --------+
> > > | UNIX_TIMESTAMP('2007-03-11 02:00:00') |
> UNIX_TIMESTAMP('2007-03-11
> > > 03:00:00') |
> > > +---------------------------------------+---------------------
> > > ----------
> > > --------+
> > > |                            1173596400 |
> > > 1173596400 |
> > > +---------------------------------------+---------------------
> > > ----------
> > > --------+
> > > 1 row in set (0.00 sec)
> > >
> > >
> > > > -----Original Message-----
> > > > From: Causevic, Dzenan [mailto:[EMAIL PROTECTED]
> > > > Sent: Wednesday, February 28, 2007 10:22 AM
> > > > To: mysql@lists.mysql.com
> > > > Subject: FW: Does MySQL require patch for Daylight Savings
> > > > Time 2007 change
> > > >
> > > > Okay but after I patch OS do I still need to load time zone
> > > > tables with
> > > > following command:
> > > >
> > > > shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u
> > root mysql
> > > >
> > > > Is this still necessary?
> > > >
> > > > _______________________________
> > > > Dzenan Causevic
> > > > Web Applications Developer
> > > > NaviSite, Inc.
> > > > 315-453-2912 x5346 (Office)
> > > > 315-278-7371 (Cell)
> > > > www.NaviSite.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: J.R. Bullington [mailto:[EMAIL PROTECTED]
> > > > Sent: Wednesday, February 28, 2007 9:40 AM
> > > > To: mysql@lists.mysql.com
> > > > Subject: re: Does MySQL require patch for Daylight
> > Savings Time 2007
> > > > change
> > > >
> > > >
> > > >                 As far as I know, MySQL does not need a
> TZ patch (unless
> > > > you use specific/custom Time Zone information), but
> your OS does.
> > > >
> > > > The best way to check is to run:
> > > >
> > > >     mysql> SHOW VARIABLES LIKE 'TIME_ZONE';
> > > >
> > > > If it says SYSTEM, then you need only patch your OS.
> > > > (Patching the OS is
> > > > [OT] for this list).
> > > >
> > > > Here's the section from the manual in regards to 3.23
> Time Zones.
> > > >
> > > > http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
> > > >
> > > > J.R.
> > > >
> > > 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 prisent courriel contient des renseignements de
> > > nature priviligiie et confidentielle et nest destini qu'` la
> > > personne ` qui il est adressi. Si vous njtes pas le
> > > destinataire privu, vous jtes par les prisentes avisis que
> > > toute diffusion, distribution ou reproduction de cette
> > > communication est strictement interdite.  Si vous avez regu
> > > ce courriel par erreur, veuillez en aviser immidiatement
> > > lexpiditeur et le supprimer de votre systhme. Notez que la
> > > transmission de courriel ne peut en aucun cas jtre considiri
> > > comme inviolable ou exempt derreur puisque les informations
> > > quil contient pourraient jtre interceptis, corrompues,
> > > perdues, ditruites, arrivies en retard ou incomplhtes ou
> > > contenir un virus.
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> >
> >
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>




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

Reply via email to