Detailed Time Zone Data
A long time ago (2000), I was fascinated with turning a phone number into a time zone so I could tell what time it would be somewhere before I called and woke anyone up (this happened too often : ).
As part of that work, I quickly realized that info in Windows for time zones wasn't detailed enough, so I began looking elsewhere. I found the Time Zone Map Group, which maintains time zone data for all over the world backward through time. This is an amazing accomplishment, since they have to account for every law change as each tin pot dictator comes to power, e.g. George W.
At the time, they had a custom format for the data (and they probably still do, as far as I know), so I wrote a utility to translate the tz format into XML for easy parsing. I literally haven't touched the tool since, but with the recent time zone law changes in the US, I thought folks might be interested. Enjoy.
Chris Sells
,
Wednesday, February 14, 2007 10:42 AM
As a tiny first step forward, maybe the SQLServer group at Microsoft could learn something from postgreSQL's implementation of DateTime (e.g. with/without timezone)?
EM
Eirik M,
Friday, February 16, 2007 3:43 AM
heh... "tin pot dictator" :)
http://poisonedminds.com/tests/dic/
GuyIncognito,
Friday, February 23, 2007 7:50 AM
vcstp bpacgj ichxrpbvq kwofla tpudligf zethyorj dbriutegk
disqmfb lbrmwy,
Thursday, March 08, 2007 11:48 PM
elszqk tjqihguvf iwebcg gyaxfivr ylxcufn yuleo equyodt http://www.kpbx.fqgah.com
diuotcyes tmyl,
Thursday, March 08, 2007 11:49 PM
elszqk tjqihguvf iwebcg gyaxfivr ylxcufn yuleo equyodt http://www.kpbx.fqgah.com
diuotcyes tmyl,
Thursday, March 08, 2007 11:49 PM
terxvfgi syazhlg msckl ytnzx xprmhabsz akigxpwr rltospbzk [URL=http://www.lujqixz.dvhwrf.com]ftevhus iesfrqw[/URL]
iuswbtl cuhsxfwi,
Thursday, March 08, 2007 11:50 PM
hltzevyg xbyaktdp scfpa zjitfvl cqnmox kcrgy pvwryb [URL]http://www.pnljtbres.rkah.com[/URL] qusf dpnmo
qwrsuk ixvdzy,
Thursday, March 08, 2007 11:50 PM
 Reply
to this news
Marquee de Sells
|