RE: MySQL Daylight Savings Time Patch

[Jerry Schwartz]

I think that's only true if the server is using the default system time
zone. In addition, you can set a per-connection time zone and use time zone
sensitive functions such as CONVERT_TZ(). All of these mean that MySQL needs
to be aware of time zone definitions. There could also be trouble if you are
using replication across time zones, I suspect.

There are explicit instructions for building time zone tables in section
5.9.8 of the manual.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]


> -----Original Message-----
> From: Paul DuBois [mailto:paul@stripped]
> Sent: Tuesday, February 20, 2007 5:17 PM
> To: Sun, Jennifer; dpgirago@stripped; mysql@stripped
> Subject: RE: MySQL Daylight Savings Time Patch
>
> At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote:
> >Any answers for the question below ?
> >
> >Is there a DST patch for MySql 4.0.20?   Thanks.
> >
> >-----Original Message-----
> >From: dpgirago@stripped [mailto:dpgirago@stripped]
> >Sent: Friday, February 09, 2007 9:30 AM
> >To: mysql@stripped
> >Subject: MySQL Daylight Savings Time Patch
> >
> >Is there a DST patch for MySQL 4.0.x series?
> >
> >I've been getting scary emails from our sys and net admins about
> >impending
> >doom.
> >
> >Thanks,
> >
> >David
>
> Before MySQL 4.1.3, the server gets its time zone from the
> operating system
> at startup.  The time zone can be specified explicitly by
> setting the TZ
> TZ environment variable setting, or by using the --timezone
> option to the
> mysqld_safe server startup script.
>
> Assuming that the server host itself has had its operating
> system updated
> to handle the new Daylight Saving Time rules, that should be
> all that's
> necessary for MySQL to know the correct time.
>
> --
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>