Questions tagged [timezone]

A time zone is a region on Earth that has a uniform, legally mandated standard time. It is often represented by an identifier, such as "America/Los_Angeles". Do not mistake an offset such as -07:00 as a time zone. A time zone is much more than that. Please read the entire tag wiki for details.

A time zone is a region on Earth that has a uniform, legally mandated standard time. As legal definitions of zones can vary wildly and change often, a database or lookup table is often required to properly apply time zone rules.

General Information About Time Zones

Almost all time zones on land have legally defined borders which coincide with the borders of the country mandating the time or some subdivision thereof. Of the time zones on land, most have a standard-time offset from Coordinated Universal Time (UTC) by a whole number of hours (UTC−12 to UTC+14), but several are offset by 30 or 45 minutes from a nearby hourly offset.

In addition to land time zones, there are 25 nautical time zones, all separated by lines of longitude. Most (UTC−11 to UTC+11) are 15° of longitude wide, which is one hour of Earth's rotation relative to the Sun, but an hourly zone in the central Pacific Ocean is split into two 7.5° wide zones (UTC±12) by the 180th meridian, part of which coincides with the International Date Line. Many land time zones are skewed toward the west relative to the corresponding nautical time zones.

Before 1972, all time zones were specified as an offset from Greenwich Mean Time (GMT), which was the mean solar time at the meridian passing through the Royal Observatory in Greenwich, London, United Kingdom. Since 1972, all official time services have broadcast radio time signals synchronized to UTC, a form of atomic time that includes leap seconds to keep it within 0.9 seconds of this former GMT, now called UT1. Many countries now legally define their standard time relative to UTC, although some still legally refer to GMT, including the United Kingdom itself. UTC, also called Zulu time, is used everywhere on Earth by astronomers and others who need to state the time of an event unambiguously.

Originally, all time on Earth was some local apparent solar time, the time on a sundial, so every city had its own time. When well-regulated mechanical clocks became widespread in the early 19th century, each city began to use some local mean solar time. The first time zone was created in 1847 by railroads on the island of Great Britain using GMT. Sandford Fleming of Canada proposed worldwide hourly time zones in 1879. By about 1900, almost all time on Earth was in the form of standard time zones, only some of which used a hourly offset from GMT. Many applied the time at a local astronomical observatory to an entire country, without any reference to GMT. It took many decades before all time on Earth was in the form of time zones referred to some "standard offset" from GMT/UTC. Nepal was the last country to adopt a standard offset, shifting slightly to UTC+5:45 in 1986. However, many countries have changed their standard offset since then, such as when North Korea shifted from UTC+9 to UTC+8:30 in 2015.

A related concept is Daylight saving time or Summer Time, which is an advance of (usually) one hour, mandated by many countries between spring and autumn.

Time Zone != Offset

A time zone can not be represented solely by an offset from UTC. Many time zones have more than one offset due to daylight saving time (aka "summer time") rules. The dates that offsets change are also part of the rules for the time zone, as are any historical offset changes. Many software programs, libraries, and web services disregard this important detail, and erroneously call the standard or current offset the "zone". This can lead to confusion, and misuse of the data. Please use the correct terminology whenever possible.

  • An offset is just a number that represents how far a particular date/time value is ahead or behind UTC.
    • Most offsets are expressed in whole hours.
    • But there are many that are 30-minute offset.
    • And there are a few that are 45-minute offset.
  • A time zone contains much more:
    • A name or ID that can be used to identify the zone.
    • One or more offsets from UTC
    • The specific dates and times that the zone transitions between offsets.
    • Sometimes, a separate language-specific display name that can be presented to a user.

One can determine the correct offset, given a time zone and a datetime. But one cannot determine the correct time zone given just an offset.

Time Zone Abbreviations

Many times you will see a time zone abbreviated using three or more letters, such as PST to abbreviate "Pacific Standard Time". However, there are many problems with time zone abbreviations:

  • They are often ambiguous. For example, there are five different interpretations of CST:

    • Central Standard Time (North America)
    • Central Standard Time (Australia)
    • Central Summer Time (Australia)
    • China Standard Time
    • Cuba Standard Time

    See also, the list of Time Zone Abbreviations on Wikipedia.

  • At best, they only represent a time zone offset, not a time zone. For example, the US Pacific Time Zone is abbreviated PST during Pacific Standard Time, but uses PDT during Pacific Daylight Time.

  • Abbreviations tend to be based on English. Sometimes there is a valid abbreviation in another language, and it may be confusing which to use.

  • Some time zones may never actually use the abbreviation in the region where the time zone is observed.

In general, if an abbreviation is used, it should be for display purposes. An abbreviation should never be parsed, or looked up in a list of values (with the exception of "UTC" or "GMT").

Time Zone Databases

There are two different time zone databases commonly used in computing:

The Microsoft Windows Time Zone Database

  • Example Identifier: "Eastern Standard Time"

You can obtain a list of these time zones by any of these methods:

  • Examine the Windows registry key at:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones

  • Use the tzutil.exe /l command line utility, looking at the second line of each result.
    (The first line is the display name.)

  • Call TimeZoneInfo.GetSystemTimeZones from .NET on Windows, looking at the Id property of the resulting TimeZoneInfo objects.

  • Call the EnumDynamicTimeZoneInformation Win32 function, looking at the TimeZoneKeyName field of the resulting DYNAMIC_TIME_ZONE_INFORMATION objects.

  • Refer to the latest version of the common/supplemental/windowsZones.xml file in the "main" branch of the Unicode CLDR project. You'll find the Windows zone identifiers in the other attribute under each zone, along with their English display names (in comments) and their mappings to IANA time zones. This list can be trusted, but note that newly established time zones will appear in Windows first, and be added to CLDR later.

  • OTHER THAN CLDR, DO NOT USE STATIC LISTS FROM WEB PAGES THAT LIST THESE WINDOWS TIME ZONES, INCLUDING THOSE FROM MICROSOFT. These should be ignored and not linked to or used as reference material. This is because time zones change over time and the lists have been modified significantly. In particular, several lists produced by Microsoft listing "time zone index values" only refer to time zones as they were for Windows Embedded 1.1, which has long been deprecated. Another list by Microsoft lists only the default time zone values per country when installing Windows for the first time. Third party lists (other than CLDR) are also suspect. Instead, use one of the aforementioned methods to list time zones on an up-to-date Windows system.

Advantages

  • Built in to Windows operating system.
  • Updates are deployed automatically through Windows Update.
  • Easy to consume from Win32 or .NET Framework on Windows.
  • As of the June 2016 update, covers everywhere on Earth, except for a few research stations in Antarctica.

Disadvantages

  • Maintained by Microsoft instead of a standards body or community.

  • Zones tend to be broad, covering multiple countries and locations, instead of refined to a specific narrow location.

  • Data for past years does not generally reach back very far into history, and is inconsistent with regard to starting year for the data that it does have for each time zone.

  • Interoperability with non-Microsoft platforms can be painful.

  • Updated monthly at best - which may or may not be frequent enough to deal with a short-notice change.

    • Previously, many changes were released only as hotfixes, but this has been changed in recent years such that all changes are deployed as regular updates.
  • Identifiers and names are confusing and assigned haphazardly. Naming conventions have varied over the years, and there is little consistency. In general, do not rely on a Windows time zone identifier to mean anything in particular. Instead, choose a time zone based on its display name.

    A few examples:

    • "Eastern Standard Time" refers to both EST and EDT.
    • "Mountain Standard Time" is for MST/MDT while "US Mountain Standard Time" is for Arizona which is fixed to MST.
    • "US Eastern Standard Time" does have daylight saving time, from 2006 forward (but not for 2005 or earlier). It's used in the majority of Indiana.
    • "Romance Standard Time" is just a synonym for Central European Time.
    • "GMT Standard Time" refers to the time in the UK and Ireland that alternates between GMT (UTC+0) and BST or IST (UTC+1), rather than strictly referring to GMT itself. (For GMT year-round, use the identifier "UTC" instead.)
    • "W. Europe Standard Time" is the id for several countries that belong to the Central European Time zone, not the Western European Time zone.
    • "AUS Eastern Standard Time" and "E. Australia Standard Time" only differ by DST.
    • "Arab Standard Time", "Arabian Standard Time", and "Arabic Standard Time" are three completely different time zones with similar names.
    • "SA Pacific Standard Time" and "Pacific SA Standard Time" are also completely different.
    • "Russia Time Zone 3", "Russia Time Zone 10" and "Russia Time Zone 11" are valid identifiers, but other Russia time zones have names instead of numbers.
    • "UTC", "UTC-02", "UTC-08", "UTC-09", "UTC-11", and "UTC+12" are valid identifiers, but other offsets are not.
  • As mentioned above, Windows time zones also have a display name.
    For example, "(UTC-05:00) Eastern Time (US & Canada)".

    • These names contain a time zone offset, but those offsets represent the standard time offset, not the current offset. This can be confusing, as the offset listed may not be the actual one in effect.
    • The display names are localized by the language settings of the Windows operating system. When used via TimeZoneInfo in .NET, the localizations are not updated to reflect the current culture or current UI culture. For example, you might have an application that serves data to an English speaking user, but when hosted on a Japanese server, the time zone display names will be presented in Japanese.

The IANA/Olson Time Zone Database

Also known as ZoneInfo, TZDB or the TZ database

  • Example Identifier: "America/New_York"

Advantages

  • Widely implemented on Linux, Mac, Java, PHP, and many other platforms.
  • Libraries are available for JavaScript and for Windows/.Net.
  • Refined, distinct time zones named from an exemplar city.
  • Covers everywhere on Earth.
  • Contains historical data for time zone changes.
  • Referenced in many RFCs and other standards.
  • Community maintained, recently backed by IANA.
  • Frequent updates, several times a year.
  • Some implementations make it easy to get updates:

Disadvantages

  • Most implementations require manual updating, such as Noda Time, Joda Time, PHP, and others. (However, the ability to update manually could actually be considered an advantage.)
  • There are so many zones, it can be difficult to present a simple drop-down list to your users. However, a map-based time zone picker, such as this one, can provide a good user experience.

Read more on Wikipedia.

Map of IANA/Olson Time Zones

This map shows the world map of IANA/Olson time zones, along with fixed offset time zones over the oceans. Note that many countries have multiple time zones.

Time zone map of the world (TZDB 2020a) Credit: Evan Siroky - Time Zone Boundary Builder project

More time zone maps are available at Time_zone in Wikipedia.

Role of the CLDR

The Unicode Common Locale Data Repository maintains localized translations of IANA/Olson time zone names, as well as mapping between Microsoft Windows identifiers and IANA/Olson identifiers.

The mapping data is available in the second table on this page, or in xml format here. Note that there is usually more than one possible IANA/Olson zone for any given Windows zone. So one can translate an Olson zone to a single Windows zone, but the other direction will yield more than one possible choice. Also note that while every Windows zone is mapped, not every IANA/Olson zone is. So it is always possible to go from a Windows zone to (one or more) IANA/Olson zones - but not necessarily the other way around.

Related: How to convert between Microsoft time zones and IANA time zones in .NET.

POSIX style time zones

Prior to acceptance of the time zone databases, the standard way to describe time zones was defined by the POSIX specification, as set in the TZ environment variable.

Examples:

  • PST8PDT
  • CET-1CEST,M3.5.0/2,M10.5.0/3
  • GRNLNDST3GRNLNDDT,M10.3.0/00:00:00,M2.4.0/00:00:00

While this compact format allows for time zone rules to be expressed without a database, it has a few disadvantages:

  • Cannot express more than two transitions in a year, so it can't handle real-world events like Egypt in 2010 or Morocco in 2012, 2013, and 2014.
  • Contains only the current time zone rules, so it cannot be used to accurately convert historical changes, such as USA before 2007.
  • Are sometimes cryptic and difficult to read.

Fortunately, most environments that accepted a TZ variable, will now allow you to pass an IANA/Olson identifier instead. For example, see the third option for working with time zones in glibc.

IBM has a good article about POSIX vs Olson time zone formats here. (This was written for AIX, but is applicable in many other contexts.)

POSIX style time zones are still useful in some cases, such as on lightweight "IoT" devices where there is not enough storage space for a full IANA time zone implementation. In such cases, a POSIX string for the current year can be generated by a back-end service that the device receives data from. Of course, this should be updated periodically, as the string could change year-over-year, or even within the year. One such library that can project POSIX strings from IANA data is TimeZoneConverter.Posix for .NET. There are other libraries and web services that can generate these values as well.

Rails Time Zone Identifiers

If you are a Ruby on Rails developer, or if you use an API from an application that was created using Rails (such as Twitter), then you may encounter time zone identifiers in a slightly different format, such as follows:

  • "Eastern Time (US & Canada)" (instead of "America/New_York")
  • "London" (instead of "Europe/London")

These identifiers are defined by Rails in the ActiveSupport::TimeZone class. The source code for this class is here. They are based on standard IANA/Olson time zones. Rails describes them as "a meaningful subset of 146 zones", however it does not describe by what criteria it determines a zone to be "meaningful".

While these particular zones should work just fine within a Rails application, you may find it difficult to use them in other contexts. For example, if you need to pass a time zone to a JavaScript library, or via a REST API to some third party, it may be difficult to consume them in Rails format. Rails developers should consider one of the two approaches:

  • When exposing a Rails time zone identifier externally, use the ActiveSupport::TimeZone::MAPPING constant, which defines a dictionary back to standard IANA/Olson zone identifers.
  • Use the Ruby TZinfo Gem instead of ActiveSupport::TimeZone. It provides access to the full IANA/Olson time zone database, and uses standard identifiers.

Related: How to convert from Microsoft time zones to Rails time zones.

12251 questions
7506
votes
10 answers

Why is subtracting these two epoch-milli Times (in year 1927) giving a strange result?

If I run the following program, which parses two date strings referencing times 1 second apart and compares them: public static void main(String[] args) throws ParseException { SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); …
Freewind
  • 193,756
  • 157
  • 432
  • 708
2183
votes
30 answers

Daylight saving time and time zone best practices

I am hoping to make this question and the answers to it the definitive guide to dealing with daylight saving time, in particular for dealing with the actual change overs. If you have anything to add, please do Many systems are dependent on keeping…
Oded
  • 489,969
  • 99
  • 883
  • 1,009
1072
votes
10 answers

DateTime vs DateTimeOffset

What is the difference between a DateTime and a DateTimeOffset and when should one be used? Currently, we have a standard way of dealing with .NET DateTimes in a TimeZone-aware way: Whenever we produce a DateTime we do it in UTC (e.g. using…
David Reis
  • 12,701
  • 7
  • 36
  • 42
972
votes
33 answers

Getting the client's time zone (and offset) in JavaScript

How can I gather the visitor's time zone information? I need both: the time zone (for example, Europe/London) and the offset from UTC or GMT (for example, UTC+01)
968
votes
10 answers

Is there a list of Pytz Timezones?

I would like to know what are all the possible values for the timezone argument in the Python library pytz. How to do it?
ipegasus
  • 14,796
  • 9
  • 52
  • 76
795
votes
16 answers

How to make a datetime object aware (not naive)

What I need to do I have a timezone-unaware datetime object, to which I need to add a time zone in order to be able to compare it with other timezone-aware datetime objects. I do not want to convert my entire application to timezone unaware for this…
Mark Tozzi
  • 10,353
  • 5
  • 22
  • 30
708
votes
27 answers

Determine a user's timezone

Is there a standard way for a web server to be able to determine a user's timezone within a web page? Perhaps from an HTTP header or part of the user-agent string?
Kevin Dente
  • 25,430
  • 7
  • 43
  • 47
674
votes
9 answers

Does Python's time.time() return the local or UTC timestamp?

Does time.time() in the Python time module return the system's time or the time in UTC?
Saransh Mohapatra
  • 9,430
  • 10
  • 39
  • 50
641
votes
21 answers

How to initialize a JavaScript Date to a particular time zone

I have date time in a particular timezone as a string and I want to convert this to the local time. But, I don't know how to set the timezone in the Date object. For example, I have Feb 28 2013 7:00 PM ET, then I can var mydate = new…
pavanred
  • 12,717
  • 14
  • 53
  • 59
576
votes
34 answers

How can I get the current date and time in UTC or GMT in Java?

When I create a new Date object, it is initialized to the current time but in the local timezone. How can I get the current date and time in GMT?
Behrang
  • 9,789
  • 6
  • 24
  • 19
524
votes
39 answers

Convert UTC date time to local date time

From the server I get a datetime variable in this format: 6/29/2011 4:52:48 PM and it is in UTC time. I want to convert it to the current user’s browser time zone using JavaScript. How this can be done using JavaScript or jQuery?
Amr Elgarhy
  • 66,568
  • 69
  • 184
  • 301
506
votes
30 answers

Create a Date with a set timezone without using a string representation

I have a web page with three dropdowns for day, month and year. If I use the JavaScript Date constructor that takes numbers, then I get a Date object for my current timezone: new Date(xiYear, xiMonth, xiDate) Give the correct date, but it thinks…
Dan
  • 7,446
  • 6
  • 32
  • 46
506
votes
36 answers

Convert date to another timezone in JavaScript

I am looking for a function to convert date in one timezone to another. It need two parameters, date (in format "2012/04/10 10:10:30 +0000") timezone string ("Asia/Jakarta") The timezone string is described in…
Rizky Ramadhan
  • 7,360
  • 4
  • 27
  • 31
482
votes
19 answers

How do I get a value of datetime.today() in Python that is "timezone aware"?

I am trying to subtract one date value from the value of datetime.datetime.today() to calculate how long ago something was. But it complains: TypeError: can't subtract offset-naive and offset-aware datetimes The return value from…
mindthief
  • 12,755
  • 14
  • 57
  • 61
474
votes
12 answers

Can't subtract offset-naive and offset-aware datetimes

I have a timezone aware timestamptz field in PostgreSQL. When I pull data from the table, I then want to subtract the time right now so I can get it's age. The problem I'm having is that both datetime.datetime.now() and datetime.datetime.utcnow()…
Ian
  • 24,116
  • 22
  • 58
  • 96
1
2 3
99 100