- August 23, 2007 4:40 PM
-----
[mysql]> select * from time_zone_transition where time_zone_id='542';
+--------------+-----------------+--------------------+
| Time_zone_id | Transition_time | Transition_type_id |
+--------------+-----------------+--------------------+
| 542 | -1633269600 | 0 |
| 542 | -1615129200 | 1 |
| 542 | -1601820000 | 0 |
| 542 | -1583679600 | 1 |
| 542 | -880207200 | 2 |
| 542 | -769395600 | 3 |
| 542 | -765385200 | 1 |
| 542 | -687967200 | 0 |
| 542 | -662655600 | 1 |
| 542 | -620834400 | 0 |
| 542 | -608137200 | 1 |
| 542 | -589384800 | 0 |
| 542 | -576082800 | 1 |
| 542 | -557935200 | 0 |
| 542 | -544633200 | 1 |
| 542 | -526485600 | 0 |
| 542 | -513183600 | 1 |
| 542 | -495036000 | 0 |
| 542 | -481734000 | 1 |
| 542 | -463586400 | 0 |
| 542 | -450284400 | 1 |
| 542 | -431532000 | 0 |
| 542 | -418230000 | 1 |
| 542 | -400082400 | 0 |
| 542 | -386780400 | 1 |
| 542 | -368632800 | 0 |
| 542 | -355330800 | 1 |
| 542 | -337183200 | 0 |
| 542 | -323881200 | 1 |
| 542 | -305733600 | 0 |
| 542 | -292431600 | 1 |
| 542 | -273679200 | 0 |
| 542 | -260982000 | 1 |
| 542 | -242229600 | 0 |
| 542 | -226508400 | 1 |
| 542 | -210780000 | 0 |
| 542 | -195058800 | 1 |
| 542 | -179330400 | 0 |
| 542 | -163609200 | 1 |
| 542 | -147880800 | 0 |
| 542 | -131554800 | 1 |
| 542 | -116431200 | 0 |
| 542 | -100105200 | 1 |
| 542 | -84376800 | 0 |
| 542 | -68655600 | 1 |
| 542 | -52927200 | 0 |
| 542 | -37206000 | 1 |
| 542 | -21477600 | 0 |
| 542 | -5756400 | 1 |
| 542 | 9972000 | 0 |
| 542 | 25693200 | 1 |
| 542 | 41421600 | 0 |
| 542 | 57747600 | 1 |
| 542 | 73476000 | 0 |
| 542 | 89197200 | 1 |
| 542 | 104925600 | 0 |
| 542 | 120646800 | 1 |
| 542 | 126698400 | 0 |
| 542 | 152096400 | 1 |
| 542 | 162381600 | 0 |
| 542 | 183546000 | 1 |
| 542 | 199274400 | 0 |
| 542 | 215600400 | 1 |
| 542 | 230724000 | 0 |
| 542 | 247050000 | 1 |
| 542 | 262778400 | 0 |
| 542 | 278499600 | 1 |
| 542 | 294228000 | 0 |
| 542 | 309949200 | 1 |
| 542 | 325677600 | 0 |
| 542 | 341398800 | 1 |
| 542 | 357127200 | 0 |
| 542 | 372848400 | 1 |
| 542 | 388576800 | 0 |
| 542 | 404902800 | 1 |
| 542 | 420026400 | 0 |
| 542 | 436352400 | 1 |
| 542 | 452080800 | 0 |
| 542 | 467802000 | 1 |
| 542 | 483530400 | 0 |
| 542 | 499251600 | 1 |
| 542 | 514980000 | 0 |
| 542 | 530701200 | 1 |
| 542 | 544615200 | 0 |
| 542 | 562150800 | 1 |
| 542 | 576064800 | 0 |
| 542 | 594205200 | 1 |
| 542 | 607514400 | 0 |
| 542 | 625654800 | 1 |
| 542 | 638964000 | 0 |
| 542 | 657104400 | 1 |
| 542 | 671018400 | 0 |
| 542 | 688554000 | 1 |
| 542 | 702468000 | 0 |
| 542 | 720003600 | 1 |
| 542 | 733917600 | 0 |
| 542 | 752058000 | 1 |
| 542 | 765367200 | 0 |
| 542 | 783507600 | 1 |
| 542 | 796816800 | 0 |
| 542 | 814957200 | 1 |
| 542 | 828871200 | 0 |
| 542 | 846406800 | 1 |
| 542 | 860320800 | 0 |
| 542 | 877856400 | 1 |
| 542 | 891770400 | 0 |
| 542 | 909306000 | 1 |
| 542 | 923220000 | 0 |
| 542 | 941360400 | 1 |
| 542 | 954669600 | 0 |
| 542 | 972810000 | 1 |
| 542 | 986119200 | 0 |
| 542 | 1004259600 | 1 |
| 542 | 1018173600 | 0 |
| 542 | 1035709200 | 1 |
| 542 | 1049623200 | 0 |
| 542 | 1067158800 | 1 |
| 542 | 1081072800 | 0 |
| 542 | 1099213200 | 1 |
| 542 | 1112522400 | 0 |
| 542 | 1130662800 | 1 |
| 542 | 1143972000 | 0 |
| 542 | 1162112400 | 1 |
| 542 | 1173607200 | 0 |
| 542 | 1194166800 | 1 |
| 542 | 1205056800 | 0 |
| 542 | 1225616400 | 1 |
| 542 | 1236506400 | 0 |
| 542 | 1257066000 | 1 |
| 542 | 1268560800 | 0 |
| 542 | 1289120400 | 1 |
| 542 | 1300010400 | 0 |
| 542 | 1320570000 | 1 |
| 542 | 1331460000 | 0 |
| 542 | 1352019600 | 1 |
| 542 | 1362909600 | 0 |
| 542 | 1383469200 | 1 |
| 542 | 1394359200 | 0 |
| 542 | 1414918800 | 1 |
| 542 | 1425808800 | 0 |
| 542 | 1446368400 | 1 |
| 542 | 1457863200 | 0 |
| 542 | 1478422800 | 1 |
| 542 | 1489312800 | 0 |
| 542 | 1509872400 | 1 |
| 542 | 1520762400 | 0 |
| 542 | 1541322000 | 1 |
| 542 | 1552212000 | 0 |
| 542 | 1572771600 | 1 |
| 542 | 1583661600 | 0 |
| 542 | 1604221200 | 1 |
| 542 | 1615716000 | 0 |
| 542 | 1636275600 | 1 |
| 542 | 1647165600 | 0 |
| 542 | 1667725200 | 1 |
| 542 | 1678615200 | 0 |
| 542 | 1699174800 | 1 |
| 542 | 1710064800 | 0 |
| 542 | 1730624400 | 1 |
| 542 | 1741514400 | 0 |
| 542 | 1762074000 | 1 |
| 542 | 1772964000 | 0 |
| 542 | 1793523600 | 1 |
| 542 | 1805018400 | 0 |
| 542 | 1825578000 | 1 |
| 542 | 1836468000 | 0 |
| 542 | 1857027600 | 1 |
| 542 | 1867917600 | 0 |
| 542 | 1888477200 | 1 |
| 542 | 1899367200 | 0 |
| 542 | 1919926800 | 1 |
| 542 | 1930816800 | 0 |
| 542 | 1951376400 | 1 |
| 542 | 1962871200 | 0 |
| 542 | 1983430800 | 1 |
| 542 | 1994320800 | 0 |
| 542 | 2014880400 | 1 |
| 542 | 2025770400 | 0 |
| 542 | 2046330000 | 1 |
| 542 | 2057220000 | 0 |
| 542 | 2077779600 | 1 |
| 542 | 2088669600 | 0 |
| 542 | 2109229200 | 1 |
| 542 | 2120119200 | 0 |
| 542 | 2140678800 | 1 |
+--------------+-----------------+--------------------+
185 rows in set (0.00 sec)
[mysql]>
[mysql]> select * from time_zone_transition_type where time_zone_id='542';
+--------------+--------------------+--------+--------+--------------+
| Time_zone_id | Transition_type_id | Offset | Is_DST | Abbreviation |
+--------------+--------------------+--------+--------+--------------+
| 542 | 0 | -25200 | 1 | PDT |
| 542 | 1 | -28800 | 0 | PST |
| 542 | 2 | -25200 | 1 | PWT |
| 542 | 3 | -25200 | 1 | PPT |
+--------------+--------------------+--------+--------+--------------+
4 rows in set (0.28 sec)
[mysql]>