Re: MySQL Daylight Savings Time Patch

[Dan Buettner]

NTP won't solve this problem for you.

NTP, as well as most computer clocks, know nothing about daylight savings
time, or about time zones.  What they know is how many seconds have elapsed
since "the epoch".  The epoch, in the case of most UNIX-based OSes, is
midnight January 1, 1970.  I think Windows is the same.  The original Mac OS
was 1/1/1904, for example.

It's up to the operating system to apply rules that determine that X number
of seconds (as reported by the clock hardware) since the epoch translates to
some human time, based on local settings for time zone and with any daylight
savings time rules for that time zone applied.

My understanding is that MySQL needs no patch, but your underlying OS most
likely does.  I know there have been patches issued for Solaris 2.x, 9 and
10, Windows XP, and Mac OS X 10.4, and almost certainly others.

HTH,
Dan


On 2/20/07, Chris White <chriswhite@stripped> wrote:
>
> 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
>
> If you're using NTP then what's the problem?  Sync to one of the ntp
> pools, boom your clocks are updated, MySQL uses system time and yay.
> I'm fairly sure you could sync 500 server this way.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>