Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

4
  • It would be nice if this were updated and I had the INSERT statements in a static .sql file rather than needing to run an exe to populate the tables! Commented Oct 16, 2023 at 18:39
  • @derekm - Thanks, but the project is now archived. I no longer work on it. The recommended approach these days is to use the built-in AT TIME ZONE function. See dba.stackexchange.com/a/312153/23221 and learn.microsoft.com/sql/t-sql/queries/at-time-zone-transact-sql Commented Oct 16, 2023 at 19:08
  • I need to translate between IANA timezone names and Windows timezone names, and I want to do it in-database without the help of application code. :( Commented Oct 17, 2023 at 20:57
  • @derekm - You could build a lookup table from the CLDR source files. You need both windowsZones.xml and timeZone.xml. The latter is used to resolve aliases. You'd also want a way to keep your table updated regularly, whenever these are modified. Commented Oct 17, 2023 at 22:31