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]{{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]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]tz database
[edit]Sub templates store data from the tz database and some related information. These examples are accurate as of version 2026c of the database.
| Code example | Produces | Description |
|---|---|---|
{{Time zone |
[https://data.iana.org/time-zones/releases/tzdata2026c.tar.gz 2026c] → 2026c |
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 |
CN | Maps TZ to country code from zone.tab |
{{Time zone |
[[ISO 3166-1:CN|CN]] → CN |
Maps TZ to linked country code from zone.tab |
{{Time zone |
+4348+08735 | Maps TZ to coordinates in original format from zone.tab |
{{Time zone |
Xinjiang Time | Maps TZ to comments from zone.tab |
{{Time zone |
asia | Maps TZ to linked continent file that defines the zone (or link) and DST rules. |
{{Time zone |
+01:00 | Maps TZ to normal (non-DST) UTC offset |
{{Time zone |
[[UTC+01:00|+01:00]] → +01:00 |
Maps TZ to linked normal (non-DST) UTC offset |
{{Time zone |
UTC+01:00 | Maps TZ to normal (non-DST) UTC offset with prefix |
{{Time zone |
+02:00 | Maps TZ to DST UTC offset |
{{Time zone |
[[UTC+02:00|+02:00]] → +02:00 |
Maps TZ to linked DST UTC offset |
{{Time zone |
| [[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 |
! scope="col" | [[ISO 3166 2-character country code|<abbr title="Country code">c.c.</abbr>]]
! scope="col" | Coordinates
! scope="col" | [[List of tz database time zones|Timezone name]]
! scope="col" | Comments
! scope="col" colspan="2" | [[UTC offset]]
|
A 6-column table header for the templates below.
Optionally, the two UTC offset columns can be merged by |
{{Time zone |
| [[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 |
| AQ
|
| Antarctica/South_Pole
|
| +12:00
| +13:00
|
Same as {{Time zone/zone.tab cols unlinked}}, but with no links |
{{Time zone |
| [[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 version of {{Time zone/zone.tab cols linked}} designed for:
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. |