Re: MySQL Daylight Savings Time Patch - easy check

[Terry Riley]

----- Original Message -----

> *From:* Ryan Stille <ryan@stripped>
> *To:* mysql@stripped
> *Date:* Sat, 24 Feb 2007 15:28:25 -0600
> 
> 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


This may depend on where you live? I tried your select above and got 
two different answers. Trying:

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

which is when BST sets in in the UK (where I am), gave me identical 
answers.

My 2 cents-worth

Terry
www.confexdb.co.uk

> 
> |
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
>