List:General Discussion« Previous MessageNext Message »
From:Alagar samy Date:March 8 2010 8:54pm
Subject:possible bug in mysql_tzinfo_to_sql
View as plain text  
i used mysql_tzinfo_to_sql utility to create timezone_* database  after upgrading zoneinfo
in my host.

after that i am seeing this mismatch. 

'America/Sao_Paulo' (http://www.timeanddate.com/worldclock/city.html?n=233) and
'America/Buenos_Aires' (http://www.timeanddate.com/worldclock/city.html?n=51) are
supposed to have same time information .. but mysql database shows differently ..  

is this a bug somewhere ? 

mysql> select * from time_zone_name where Time_zone_id in (59,185);
+--------------------------------+--------------+
| Name                           | Time_zone_id |
+--------------------------------+--------------+
| America/Argentina/Buenos_Aires |           59 |
| America/Sao_Paulo              |          185 |
+--------------------------------+--------------+
2 rows in set (0.00 sec)


mysql> select * from time_zone_transition_type where Time_zone_id=185;
+--------------+--------------------+--------+--------+--------------+
| Time_zone_id | Transition_type_id | Offset | Is_DST | Abbreviation |
+--------------+--------------------+--------+--------+--------------+
|          185 |                  0 | -11188 |      0 | LMT          |
|          185 |                  1 |  -7200 |      1 | BRST         |
|          185 |                  2 | -10800 |      0 | BRT          |
+--------------+--------------------+--------+--------+--------------+
3 rows in set (0.00 sec)

mysql> select * from time_zone_transition_type where Time_zone_id=59;
+--------------+--------------------+--------+--------+--------------+
| Time_zone_id | Transition_type_id | Offset | Is_DST | Abbreviation |
+--------------+--------------------+--------+--------+--------------+
|           59 |                  0 | -15408 |      0 | CMT          |
|           59 |                  1 | -14400 |      0 | ART          |
|           59 |                  2 | -10800 |      1 | ARST         |
|           59 |                  3 |  -7200 |      1 | ARST         |
|           59 |                  4 | -10800 |      0 | ART          |
+--------------+--------------------+--------+--------+--------------+
5 rows in set (0.00 sec)

mysql> select convert_tz(now(), @@global.time_zone, 'America/Sao_Paulo');
+------------------------------------------------------------+
| convert_tz(now(), @@global.time_zone, 'America/Sao_Paulo') |
+------------------------------------------------------------+
| 2010-03-08 17:48:16                                        |
+------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select convert_tz(now(), @@global.time_zone,'America/Buenos_Aires');
+--------------------------------------------------------------+
| convert_tz(now(), @@global.time_zone,'America/Buenos_Aires') |
+--------------------------------------------------------------+
| 2010-03-08 18:48:28                                          |
+--------------------------------------------------------------+
1 row in set (0.00 sec)


A.Alagarsamy



      Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
http://downloads.yahoo.com/in/internetexplorer/
Thread
possible bug in mysql_tzinfo_to_sqlAlagar samy8 Mar