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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
