David
March 19, 2020, 5:02pm
1
Of the new tags in 7.9, there are some for Timezone . Where is a list of all the possible values for this tag? There’s no mention of this in the manual, that I can find. We need to have all the values so we can translate it to the SQL Server equivalent.
You can get a list for yourself, it comes straight from Java:
print java.util.TimeZone.getAvailableIDs()
David
March 19, 2020, 5:41pm
3
Thanks. The code works, but I got a bit more than I was expecting…
Machine readable list of Microsoft timezone names to TZDB names:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE supplementalData SYSTEM "../../common/dtd/ldmlSupplemental.dtd">
<!--
Copyright © 1991-2013 Unicode, Inc.
CLDR data files are interpreted according to the LDML specification (http://unicode.org/reports/tr35/)
For terms of use, see http://www.unicode.org/copyright.html
-->
<supplementalData>
<version number="$Revision$"/>
<windowsZones>
<mapTimezones otherVersion="7e11200" typeVersion="2019b">
<!-- (UTC-12:00) International Date Line West -->
<mapZone other="Dateline Standard Time" territory="001" type="Etc/GMT+12"/>
<mapZone other="Dateline Standard Time" territory="ZZ" type="Etc/GMT+12"/>
<!-- (UTC-11:00) Coordinated Universal Time-11 -->
<mapZone other="UTC-11" territory="001" type="Etc/GMT+11"/>
<mapZone other="UTC-11" territory="AS" type="Pacific/Pago_Pago"/>
show original
1 Like