I got a problem concerning the mysql configuration regarding the set timezone. I have a query which uses the function UNIX_TIMESTAMP on a datetime field, but it creates a unix timestamp which is 24 seconds to high.
During installation the timezone Europe/Paris was automatically recognized and set and I switched it to Europe/Berlin in php.ini and my.ini, but that didn't solve the problem. Here are some additional facts:
- I can get the correct unixtimestamp with the PHP function strtotime and then use http://www.unixtime.de
to get the right string again.
- I can edit the value using HeidiSQL, but the value is alsways 24 seconds to high
- I visitied http://dev.mysql.com/doc/refman/5.1/en/timezone-problems.html
, but I did not find any information, if "Europe/Berlin" is acceptable for windows (I googled using combination of "Windows, MySQL, timezones, identifier")
- I checked the current server used "timestamp" and "time_zone" value, which are both correct ("Europe/Berlin" is set and the timestamp is exactly the time on my computer)
- I updated the timezone tables (http://dev.mysql.com/downloads/timezones.html
) and switch back changing nothing.
I have know additional ideas for solving this problem. One hour to high/low I would get, but not 24 seconds (Is it some calculated time difference between Berlin-Paris? I don't think so).
I would be happy for additional thoughts and ideas and maybe an solution to this problem
Thanks for reading.
I noticed this post discribes the same problem: viewtopic.php?f=4&t=40427