----- Original Message -----
> *From:* Ryan Stille <[EMAIL PROTECTED]>
> *To:* [email protected]
> *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/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
