List:General Discussion« Previous MessageNext Message »
From:Jean-Sebastien Pilon Date:February 28 2007 3:54pm
Subject:RE: Does MySQL require patch for Daylight Savings Time 2007 change
View as plain text  
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@stripped] 
> Sent: Wednesday, February 28, 2007 10:22 AM
> To: mysql@stripped
> 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@stripped] 
> Sent: Wednesday, February 28, 2007 9:40 AM
> To: mysql@stripped
> 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 pr
Thread
FW: Does MySQL require patch for Daylight Savings Time 2007 changeDzenan Causevic28 Feb
  • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJean-Sebastien Pilon28 Feb
    • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz28 Feb
      • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJean-Sebastien Pilon28 Feb
        • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz28 Feb
          • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJean-Sebastien Pilon28 Feb
            • RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz28 Feb
RE: Does MySQL require patch for Daylight Savings Time 2007 changeJerry Schwartz13 Mar