I'm not exactly sure what you should do, hence my earlier question about
the empty time zone tables. I get the same (correct) result on both of
my servers - on one of them I've updated the MySQL time zone tables, and
on the other the tables are empty, always have been. Hopefully someone
will weigh in on this.
Is your OS updated? On Linux you can check by running 'zdump -v
/etc/localtime | grep 2007'. You should see some lines mentioning March 11.
If your OS is not ready for the change, that could be your problem.
You could also try updating the MySQL timezone tables, as was mentioned
earlier in this thread. I did mine with this command:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql mysql -p
And yes I got a few errors, as other people have mentioned in this
thread. But they all appear to be related to overseas timezones so I'm
not too concerned about them.
-Ryan
Mike Blezien wrote:
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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]