From: Date: February 24 2007 10:38pm
Subject: Re: MySQL Daylight Savings Time Patch - easy check
List-Archive: http://lists.mysql.com/mysql/205211
Message-Id: <000701c7585c$10512f60$04fea8c0@DGGTPQ11>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

Out of curiousity, what should be done if they results are different. We checked 
on one of boxes and got two different results:

SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),
    -> UNIX_TIMESTAMP('2007-03-11 03:00:00');
+---------------------------------------+---------------------------------------+
| UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11 03:00:00') 
|
+---------------------------------------+---------------------------------------+
|                            1173600000 |                            1173603600 
|
+---------------------------------------+---------------------------------------+

Thx's
Mickalo
----- Original Message ----- 
From: "Ryan Stille" <ryan@stripped>
To: <mysql@stripped>
Sent: Saturday, February 24, 2007 3:28 PM
Subject: Re: MySQL Daylight Savings Time Patch - easy check


> 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