Template:Time zone/database table
 | This template uses Lua: |
Builds a wikitable of tz database attributes of multiple time zones, using {{Time zone/database header}} and {{Time zone/zone.tab cols wiki6}}.
Usage
For the basic use case, the unnamed parameters of {{Time zone/database table}} accept timezone names from the tz database. Each present unnamed parameter adds one row to the generated table. For example:
{{Time zone/database table
| America/New_York
| Europe/Berlin
| Asia/Hong_Kong
| Australia/Sydney
| Antarctica/South_Pole
}}
| c.c. | Coordinates | Timezone name | Comments | UTC offset (Std.) | UTC offset (DST) |
|---|---|---|---|---|---|
| US | +404251 |
America
|
Eastern (most areas) | −05:00 | −04:00 |
| DE | +5230 |
Europe
|
most of Germany | +01:00 | +02:00 |
| HK | +2217 |
Asia
|
+08:00 | +08:00 | |
| AU | −3352 |
Australia
|
New South Wales (most areas) | +10:00 | +11:00 |
| AQ | Antarctica
|
+12:00 | +13:00 |
same dst
|same dst= is passed onto {{Time zone/zone.tab cols wiki6}}, to modify the DST cells that are identical to the standard time cell. For example, with |same dst=n/a:
{{Time zone/database table
| same dst = n/a
| America/Phoenix
| Europe/Berlin
| Asia/Hong_Kong
| Asia/Tokyo
| Australia/Sydney
}}
| c.c. | Coordinates | Timezone name | Comments | UTC offset (Std.) | UTC offset (DST) |
|---|---|---|---|---|---|
| US | +332654 |
America
|
MST – AZ (most areas), Creston BC | −07:00 | N/a |
| DE | +5230 |
Europe
|
most of Germany | +01:00 | +02:00 |
| HK | +2217 |
Asia
|
+08:00 | N/a | |
| JP | +353916 |
Asia
|
Eyre Bird Observatory | +09:00 | N/a |
| AU | −3352 |
Australia
|
New South Wales (most areas) | +10:00 | +11:00 |
DST header
Specifically for |same dst=merge. If all regions do not observe DST, then the UTC offset header cells from {{Time zone/database header}} are merged automatically, and the table shows one column of UTC offset:
{{Time zone/database table
| same dst = merge
| America/Phoenix
| Asia/Hong_Kong
| Asia/Tokyo
}}
| c.c. | Coordinates | Timezone name | Comments | UTC offset | |
|---|---|---|---|---|---|
| US | +332654 |
America
|
MST – AZ (most areas), Creston BC | −07:00 | |
| HK | +2217 |
Asia
|
+08:00 | ||
| JP | +353916 |
Asia
|
Eyre Bird Observatory | +09:00 | |
If some regions observe DST, then both header cells are shown:
{{Time zone/database table
| same dst = merge
| Europe/Berlin
| Asia/Hong_Kong
| Australia/Sydney
}}
| c.c. | Coordinates | Timezone name | Comments | UTC offset (Std.) | UTC offset (DST) |
|---|---|---|---|---|---|
| DE | +5230 |
Europe
|
most of Germany | +01:00 | +02:00 |
| HK | +2217 |
Asia
|
+08:00 | ||
| AU | −3352 |
Australia
|
New South Wales (most areas) | +10:00 | +11:00 |
Limitation
The table from this template does not allow extra columns or rows. Substitute this template ({{subst:Time zone/database table|...}}) to generate a starting table.
TemplateData
TemplateData for Time zone/database table
Builds a wikitable of tz database attributes of multiple time zones, using {{Time zone/database header}} and {{Time zone/zone.tab cols wiki6}}.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| DST column options | same dst | Controls the DST UTC offset column display, when both standard time and DST have the same UTC offset on a row
| Unknown | optional |
| Timezone name 1 | 1 | First time zone name as defined in the tz database
| String | required |
| Timezone name 2 | 2 | Second time zone name as defined in the tz database
| String | 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
|
[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. |
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.