From: Johan De Meersman Date: October 14 2010 6:23am Subject: Re: How do I use and JOIN the mysql.time_zone% tables? List-Archive: http://lists.mysql.com/mysql/223323 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf301d3c222acdc304928dc0e8 --20cf301d3c222acdc304928dc0e8 Content-Type: text/plain; charset=ISO-8859-1 Part of your answer is the offset column, which seems to be relative to the abbreviation used. This implies, to me, that each particular abbreviation has it's own way of specifying the "starting point" of the time. Added is the DST flag, which (probably) tells you that your app needs to keep daylight savings time in mind. I can't tell you why there are so many, or which one to pick, but there you go. Just, you know, pick one, learn it's rules and stick to it. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --20cf301d3c222acdc304928dc0e8--