List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:February 24 2007 9:38pm
Subject:Re: MySQL Daylight Savings Time Patch - easy check
View as plain text  
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

Thread
MySQL Daylight Savings Time Patchdpgirago9 Feb
  • RE: MySQL Daylight Savings Time PatchJennifer Sun20 Feb
    • Re: MySQL Daylight Savings Time PatchChris White20 Feb
      • Re: MySQL Daylight Savings Time PatchDan Buettner20 Feb
        • RE: MySQL Daylight Savings Time PatchJennifer Sun20 Feb
  • Re: MySQL Daylight Savings Time PatchAaron Cannon21 Feb
  • Re: MySQL Daylight Savings Time Patch - easy checkMike Blezien24 Feb
    • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille24 Feb
  • Re: MySQL Daylight Savings Time Patch - easy checkMike Blezien24 Feb
RE: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
  • RE: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
    • Re: MySQL Daylight Savings Time PatchRyan Stille20 Feb
      • Re: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
        • Re: MySQL Daylight Savings Time PatchRyan Stille24 Feb
          • Re: MySQL Daylight Savings Time PatchRyan Stille24 Feb
          • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille24 Feb
            • Re: MySQL Daylight Savings Time Patch - easy check(Terry Riley)25 Feb
            • RE: MySQL Daylight Savings Time Patch - easy checkJerry Schwartz28 Feb
              • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille28 Feb
                • Re: MySQL Daylight Savings Time Patch - easy checkWilliam R. Mussatto28 Feb
                  • Re: MySQL Daylight Savings Time Patch - easy checkNĂ©stor1 Mar
                    • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille1 Mar
                • RE: MySQL Daylight Savings Time Patch - easy checkJerry Schwartz1 Mar
                • RE: MySQL Daylight Savings Time Patch - easy checkJerry Schwartz1 Mar
  • RE: MySQL Daylight Savings Time PatchJerry Schwartz21 Feb
RE: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
  • RE: MySQL Daylight Savings Time PatchJerry Schwartz21 Feb