MySQL displaying wrong time for some timezones -


I am using MySQL 5.1.34 community server. I have taken the MySQL timezone description tables from.

Now, the time displayed by MySQL for some timezones is inaccurate, because calculating the wrong "light saving of the day" for these time zones.

Ex: Query

  Choose convert_tease (now (), 'GMT', 'Australia / Sydney');  

Giving wrong results.

The wrong time for the following timezones is shown: America / São Paulo America / Caracas America / Buenos Aires Asia / Karachi Asia / Dhaka Australia / Adelaide Australia / Sydney

But all other timezones (excluding top ones) "light savings of day" is accurate and it displays the right time.

What am I missing here? What will help to update to a later version of MySQL?

My timing table was not updated. Just updated them and now everything is working fine.


Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -