Thomas Munro <thomas.mu...@gmail.com> writes: >> Yes, it's been a while but IIRC Windows in the UK uses confusing >> terminology here even in user interfaces, so that in summer it appears >> to be wrong, which is annoying to anyone brought up on Eggert's >> system. The CLDR windowsZones.xml file shows this.
BTW, on closer inspection of CLDR's data, the Windows zone name they associate with Europe/London is "GMT Standard Time". "Greenwich Standard Time" is associated with a bunch of places that happen to lie near the prime meridian, but whose timekeeping likely has nothing to do with UK civil time: <!-- (UTC+00:00) Monrovia, Reykjavik --> <mapZone other="Greenwich Standard Time" territory="001" type="Atlantic/Reykjavik"/> <mapZone other="Greenwich Standard Time" territory="BF" type="Africa/Ouagadougou"/> <mapZone other="Greenwich Standard Time" territory="CI" type="Africa/Abidjan"/> <mapZone other="Greenwich Standard Time" territory="GH" type="Africa/Accra"/> <mapZone other="Greenwich Standard Time" territory="GL" type="America/Danmarkshavn"/> <mapZone other="Greenwich Standard Time" territory="GM" type="Africa/Banjul"/> <mapZone other="Greenwich Standard Time" territory="GN" type="Africa/Conakry"/> <mapZone other="Greenwich Standard Time" territory="GW" type="Africa/Bissau"/> <mapZone other="Greenwich Standard Time" territory="IS" type="Atlantic/Reykjavik"/> <mapZone other="Greenwich Standard Time" territory="LR" type="Africa/Monrovia"/> <mapZone other="Greenwich Standard Time" territory="ML" type="Africa/Bamako"/> <mapZone other="Greenwich Standard Time" territory="MR" type="Africa/Nouakchott"/> <mapZone other="Greenwich Standard Time" territory="SH" type="Atlantic/St_Helena"/> <mapZone other="Greenwich Standard Time" territory="SL" type="Africa/Freetown"/> <mapZone other="Greenwich Standard Time" territory="SN" type="Africa/Dakar"/> <mapZone other="Greenwich Standard Time" territory="TG" type="Africa/Lome"/> So arguably, the problem that started this thread was Andres' user error: I doubt he expected "Greenwich Standard Time" to mean any of these. Still, I think we're better off to map that to London, because he won't be the only one to make that mistake. BTW, I find those "territory" annotations in the CLDR data to be fascinating. If that corresponds to something that we could retrieve at runtime, it'd allow far better mapping of Windows zones than we are doing now. I have no interest in working on that myself though. regards, tom lane