Template:Time zone/database header

c.c.	Coordinates	Timezone name	Comments	UTC offset (Std.)	UTC offset (DST)

Template documentationviewedithistorypurge

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

{{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+11409	Asia/Hong_Kong		+08:00	+08:00
US	+332654−1120424	America/Phoenix	MST – AZ (most areas), Creston BC	−07:00	−07:00
DE	+5230+01322	Europe/Berlin	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+11409	Asia/Hong_Kong		+08:00
US	+332654−1120424	America/Phoenix	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+11409	Asia/Hong_Kong		+08:00		No DST
US	+332654−1120424	America/Phoenix	MST – AZ (most areas), Creston BC	−07:00		No DST
DE	+5230+01322	Europe/Berlin	most of Germany	+01:00	+02:00	Uses DST

TemplateData

This is the TemplateData for this template used by TemplateWizard, VisualEditor and other tools. See a monthly parameter usage report for Template:Time zone/database header in articles based on its TemplateData.

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.

Template parameters[Edit template data]

This template prefers inline formatting of parameters.

Parameter		Description	Type	Status
Show DST?	dst	Whether to show a separate DST column Suggested values no yes Default yes Auto value no	Unknown	optional

See also

tz database

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/version|IncludeLink}}	[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/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]] → 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]] → +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]] → +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/database header|dst=no}}	! 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 |dst=no, designed for {{Time zone/zone.tab cols wiki6}}.
{{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 version of {{Time zone/zone.tab cols linked}} designed for: sortable tables, by including sort keys; and tables of TZs with and without DST, by allowing different display behaviours for the DST column. 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.

The above documentation is transcluded from Template:Time zone/database header/doc. (edit | history)
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Add categories to the /doc subpage. Subpages of this template.