SEO

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:bullijr@innovatim.com]
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/...e-support.html

J.R.

----------------------------------------

From: "Causevic, Dzenan"
<dcausevic@navisite.com>
Sent: Wednesday, February 28, 2007 9:29 AM
To: mysql@lists.mysql.com
Subject: Does MySQL require patch for Daylight Savings Time 2007 change

I am running Apache HTTP 1.3 with PHP 4.2.2 and MySQL 3.23.

Do I need to apply any kind of patches to my MySQL related to Daylight
Savings Time 2007 change?

_______________________________

Dzenan Causevic

Web Applications Developer

NaviSite, Inc.

315-453-2912 x5346 (Office)

315-278-7371 (Cell)

www.NaviSite.com

This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.



This e-mail is the property of NaviSite, Inc. It is intended only
for the person or entity to which it is addressed and may contain
information that is privileged, confidential, or otherwise protected
from disclosure. Distribution or copying of this e-mail, or the
information contained herein, to anyone other than the intended
recipient is prohibited.

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:dcausevic@navisite.com]
> 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:bullijr@innovatim.com]
> 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/...e-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 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. *

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:jspilon@PENSON.CA]
> 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:dcausevic@navisite.com]
> > 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:bullijr@innovatim.com]
> > 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/...e-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/mysql?unsub=j...e-infoshop.com
>
>

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:jschwartz@the-infoshop.com]
> 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:jspilon@PENSON.CA]
> > 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:dcausevic@navisite.com]
> > > 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:bullijr@innovatim.com]
> > > 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/...e-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/mysql?unsub=j...e-infoshop.com
> >
> >
>
>
>
>

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:jspilon@PENSON.CA]
> 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:jschwartz@the-infoshop.com]
> > 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:jspilon@PENSON.CA]
> > > 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:dcausevic@navisite.com]
> > > > 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:bullijr@innovatim.com]
> > > > 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/...e-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/mysql?unsub=j...e-infoshop.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
>
>

You ran your zdump -v against this file ?


> -----Original Message-----
> From: Jerry Schwartz [mailto:jschwartz@the-infoshop.com]
> 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:jspilon@PENSON.CA]
> > 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. *

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: 860.674.8341


> -----Original Message-----
> From: Jean-Sebastien Pilon [mailto:jspilon@PENSON.CA]
> 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:jschwartz@the-infoshop.com]
> > 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:jspilon@PENSON.CA]
> > > 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. *
>