From: Date: February 24 2007 10:28pm
Subject: Re: MySQL Daylight Savings Time Patch - easy check
List-Archive: http://lists.mysql.com/mysql/205210
Message-Id: <45E0ADF9.4020700@cfwebtools.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ryan Stille wrote:
> Paul DuBois wrote:
>> At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
>>> Is there an easy way to test to see if MySQL already has the proper 
>>> tables loaded?
>>>
>>> -Ryan
>>
>> Yes, reload them. :-)  After that, they're current! .......
>>

After digging around on the net for a while I found an easy way to tell 
if your MySQL installation is ready for the new daylight savings time.

SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),  
UNIX_TIMESTAMP('2007-03-11 03:00:00');

This should return the same value, even though you are feeding it 
different times, because this is when the 1 hr change occurs.  I get the 
correct result on both of my machines.  On one of them I've run the 
suggested |mysql_tzinfo_to_sql command, on the other, the time zone 
tables are completely empty!

Any wisdom on these time zone tables - are they ever used, should I 
populate them or not?

-Ryan

|