Re: Will MySQL Be Patched for 2007 Daylight Saving Time

[Sergei Golubchik]

Hi!

On Nov 27, Troy.Travis@stripped wrote:
> To whom it may concern,
> We are currently using Bugzilla and PHPBB, both of which are backed by the 
> MySQL dB an a Linux server (CentOS).
> Could someone please tell me if MySQL is going to need a patch due to the 
> new (2007) Daylight Saving Time U.S change.
> 
> Thank you very much in advance.
>  
>      - Troy 

The timezone tables are available for download from

 http://dev.mysql.com/downloads/timezones.html

And this page also contains a warning:
"
Attention! Please don't use this package if your system includes
zoneinfo files (e.g. Linux, FreeBSD, Sun Solaris), please generate the
mysql.time_zone* tables from those files using the mysql_tzinfo_to_sql
utility instead! (Otherwise you may cause a difference in datetime
handling between MySQL and other applications on your system.)
"

So, you shouldn't download the tables, but generate them on your CentOS
server. If it suppors new Daylight Saving Time U.S change - so will
MySQL.

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Kerpen, Germany
       <___/  www.mysql.com