Re: How do I use and JOIN the mysql.time_zone% tables?

2010-10-14 Thread Johan De Meersman
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

RE: How do I use and JOIN the mysql.time_zone% tables?

2010-10-14 Thread Jerry Schwartz
Interesting question -- I hope someone can give an in-depth explanation. I've created some TZ processing to use in Access, to go back and forth from local time to UTC (which Access doesn't make easy). To do this, I had to find and reformat some official files so I could cram them into Access