: 860.674.8341
-Original Message-
From: gladius pauline [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 3:04 PM
To: Jerry Schwartz
Subject: RE: Does MySQL require patch for Daylight Savings
Time 2007 change
Thanks a lot and i tried
show variables like '%time%';
i got
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]
Version 4.1.3 - relies on the O/S for DST
Quote from http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
For versions of MySQL older than 4.1.3 that do not have time zone
support, the server always tracks the operating system time (much like a
time zone setting of SYSTEM in 4.1.3 and
-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
, 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
: 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
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
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
-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