To be honest, time zones in Windows is a mess. Here, in these two articles, we will focus on maximising the information you can retrieve directly from Windows. This will be discussed in a later article. Due to its nature, however, this database is not just a set of tables you can look up to query this vast database, special tools are needed. Therefore, it is necessary to track the changes and record these to be able to obtain the time zone of a location at a given time.įor the IT industry, this is taken care of by IANA, which maintains a database, IANA Time Zone Database, holding all information about past and planned future changes of time zones and their locations. That is not so and, even worse, the time zone may change over time. It would be nice and convenient if the time zone of a location could be calculated directly from its coordinates. In 1940, Spain decided to move to the Central European Time time zone even though the country lines up with the United Kingdom. Take, for example, daylight saving time or the date line that zigzags its way down the Pacific Ocean because some small countries adjacent the true date line have decided to belong to another time zone to "stay ahead" of the other countries. The second covers how to store, present, and select time zones: Time Zones, Windows, and Microsoft Office - Part 2Įven though time zones as such origin from the astronomical fact, that the Earth is spinning, time zones are not purely defined by science, math, or coordinates but are often a result of political decisions. This is the first article about maximising the usage of time zones in Windows with Microsoft Access and Excel.
0 Comments
Leave a Reply. |