Template:Time zone/database header
| c.c. | Coordinates | Timezone name | Comments | UTC offset (Std.) | UTC offset (DST) |
|---|
This template creates 6 header cells in a table row: country code, coordinates, timezone name, comments, standard UTC offset, and DST UTC offset.
The two UTC offset header cells may be merged for list of timezones that do not use DST, using |dst=no.
The headers are compatible with sortable tables, and with 6-column {{Time zone/zone.tab cols...}} row templates:
- {{Time zone/zone.tab cols wiki6}}
- {{Time zone/zone.tab cols linked}}
- {{Time zone/zone.tab cols unlinked}}
Usage
[edit source]{{Time zone/database header}} has one optional parameter |dst=no to merge the two UTC offset header cells. By default, both header cells are shown:
{| class="wikitable sortable"
! {{Time zone/database header}}
|-
| {{Time zone/zone.tab cols wiki6|Asia/Hong_Kong}}
|-
| {{Time zone/zone.tab cols wiki6|America/Phoenix}}
|-
| {{Time zone/zone.tab cols wiki6|Europe/Berlin}}
|}
| c.c. | Coordinates | Timezone name | Comments | UTC offset (Std.) | UTC offset (DST) |
|---|---|---|---|---|---|
| HK | +2217 |
Asia
|
+08:00 | +08:00 | |
| US | +332654 |
America
|
MST – AZ (most areas), Creston BC | −07:00 | −07:00 |
| DE | +5230 |
Europe
|
most of Germany | +01:00 | +02:00 |
With {{Time zone/database header|dst=no}}, the two headers are merged. This may be useful if all following rows also have the DST cells merged, for example with {{Time zone/zone.tab cols wiki6|tz|same dst=merge}}:
{| class="wikitable sortable"
! {{Time zone/database header|dst=no}}
|-
| {{Time zone/zone.tab cols wiki6|Asia/Hong_Kong|same dst=merge}}
|-
| {{Time zone/zone.tab cols wiki6|America/Phoenix|same dst=merge}}
|}
| c.c. | Coordinates | Timezone name | Comments | UTC offset | |
|---|---|---|---|---|---|
| HK | +2217 |
Asia
|
+08:00 | ||
| US | +332654 |
America
|
MST – AZ (most areas), Creston BC | −07:00 | |
If any timezone is updated and introduces DST, then the article editor will be responsible for manually removing the parameter. Otherwise, the UTC offset header will fail to describe the two columns:
{| class="wikitable sortable"
! {{Time zone/database header|dst=no}} !! Note
|-
| {{Time zone/zone.tab cols wiki6|Asia/Hong_Kong|same dst=merge}} || No DST
|-
| {{Time zone/zone.tab cols wiki6|America/Phoenix|same dst=merge}} || No DST
|-
| {{Time zone/zone.tab cols wiki6|Europe/Berlin|same dst=merge}} || Uses DST
|}
| c.c. | Coordinates | Timezone name | Comments | UTC offset | Note | |
|---|---|---|---|---|---|---|
| HK | +2217 |
Asia
|
+08:00 | No DST | ||
| US | +332654 |
America
|
MST – AZ (most areas), Creston BC | −07:00 | No DST | |
| DE | +5230 |
Europe
|
most of Germany | +01:00 | +02:00 | Uses DST |
TemplateData
[edit source]TemplateData for Time zone/database header
Creates 6 header cells in a table row: country code, coordinates, timezone name, comments, standard UTC offset, and DST UTC offset.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Show DST? | dst | Whether to show a separate DST column
| Unknown | optional |
See also
[edit source]tz database
[edit source]Sub templates store data from the tz database and some related information. These examples are accurate as of version 2025c of the database.
| Code example | Produces | Description |
|---|---|---|
{{Time zone/version|IncludeLink}}
|
[https://data.iana.org/time-zones/releases/tzdata2025c.tar.gz 2025c]
|
Produces the version number of the tz database. Update this template when updating those below with data from a new release. Add a parameter (value doesn't matter) to include a link to the IANA FTP site. |
{{Time zone/country code|Asia/Urumqi}}
|
CN | Maps TZ to country code from zone.tab |
{{Time zone/iso 3166-1 link|Asia/Urumqi}}
|
[[ISO 3166-1:CN|CN]]
|
Maps TZ to linked country code from zone.tab |
{{Time zone/coordinates|Asia/Urumqi}}
|
+4348+08735 | Maps TZ to coordinates in original format from zone.tab |
{{Time zone/comments|Asia/Urumqi}}
|
Xinjiang Time | Maps TZ to comments from zone.tab |
{{Time zone/rulefile|Asia/Urumqi}}
|
asia | Maps TZ to linked continent file that defines the zone (or link) and DST rules. |
{{Time zone/utc offset|Europe/Amsterdam}}
|
+01:00 | Maps TZ to normal (non-DST) UTC offset |
{{Time zone/utc offset link|Europe/Amsterdam}}
|
[[UTC+01:00|+01:00]]
|
Maps TZ to linked normal (non-DST) UTC offset |
{{Time zone/utc zone|Europe/Amsterdam}}
|
UTC+01:00 | Maps TZ to normal (non-DST) UTC offset with prefix |
{{Time zone/utc dst offset|Europe/Amsterdam}}
|
+02:00 | Maps TZ to DST UTC offset |
{{Time zone/utc dst offset link|Europe/Amsterdam}}
|
[[UTC+02:00|+02:00]]
|
Maps TZ to linked DST UTC offset |
{{Time zone/zone.tab cols wikitable|Antarctica/South_Pole}}
|
| [[ISO 3166-1:AQ|AQ]] || || [[Antarctica/South_Pole]] ||
|
Maps TZ to 4 elements as a wikitable row – country code, coordinates, zone name, and comments |
{{Time zone/zone.tab cols linked|Antarctica/South_Pole}}
|
| [[ISO 3166-1:AQ|AQ]]
|
| Antarctica/South_Pole
|
| [[UTC+12:00|+12:00]]
| [[UTC+13:00|+13:00]]
|
Similar to {{Time zone/zone.tab cols wikitable}}, but adds two more lines to the output, containing the linked normal (non-DST) and DST UTC offsets |
{{Time zone/zone.tab cols unlinked|Antarctica/South_Pole}}
|
| AQ
|
| Antarctica/South_Pole
|
| +12:00
| +13:00
|
Same as {{Time zone/zone.tab cols unlinked}}, but with no links |
{{Time zone/zone.tab cols wiki6|Antarctica/South_Pole}}
|
| [[ISO 3166-1:AQ|AQ]]
|
| <div style="text-indent: -1.6em; margin-left: 1.6em;">Antarctica<wbr />/South_Pole</div>
|
| data-sort-value="43200" | [[UTC+12:00|+12:00]]
| data-sort-value="46800" | [[UTC+13:00|+13:00]]
|
A possibly slower version of {{Time zone/zone.tab cols linked}}.
Note: neither {{Time zone/zone.tab cols wiki6}} nor {{Time zone/zone.tab cols linked}} can currently be used for the full table in List of tz database time zones because of performance limitations in processing such a long table. They can, however, be used for a small number of rows in individual area articles. |