Some of zone records use 3 or 4 letter abbreviations that are tied to physical time zones, others use numeric UTC offsets. Time zone abbreviations for both Standard Time and Daylight Saving Time are shown exactly as they appear in the database. The Time Zone Database (often called tz or zoneinfo) contains code and data that represent the history of local time for many representative locations. either an IANA time zone, including information about the time zone, such as the offset between the local time and UTC at a particular time, daylight saving. This table does not attempt to document any of the historical data which resides in the database. Anyway, our example say someone in Reykjavík, Iceland with 3 minutes after midnight on the clock hanging on their wall makes a phone call to someone in the US. The UTC offsets are based on the current or upcoming database rules. At least currently today their wall-clock time matches UTC in the past or future it may be different, which is why it is incorrect to say UTC is the time zone of Iceland.
Standard Time ( STD) and Daylight Saving Time ( DST) offsets from UTC in hours and minutes.įor zones in which Daylight Saving is not observed, the DST offset shown in this table is a simple duplication of the STD offset.
Historical data for such zones is still preserved in the source code, but it is not included when compiling the database with standard options. The dagger symbol (†) signifies that the zone was canonical in a previous version of the database. Note that created moments have equal UTC time because these moments were created in a default timezone. In the case of your question it isnt clear whether you want to store the time in UTC but display it in the servers local time (TimeZone), or whether you wan to ignore TimeZone and always display it as UTC.
#Utc time zone name how to#
Link - An alternative name (alias) which links to a canonical zone. This is covered in the manual, but its not always obvious how to actually work with dates/times.The SQL spec is a bit bizarre.Canonical - The primary, preferred zone name.
This is a list of time zones from release 2023c of the tz database. World map showing time zones from the tz database version 2017a
0 kommentar(er)
