clickhouse的日期处理

实现以下按分钟聚合：

select formatDateTime(dt,'%Y-%m-%d %p %H:%M','Asia/Shanghai') as dd
,count(*),COUNT(DISTINCT deviceId ) 
from log_check_detail where dt > '2022-09-19' 
group by dd 
order by dd desc 

注意：

1.日期处理函数

2.时区

执行结果：

 

技术性解释：

一、主要函数

 formatDateTime()
解析:函数根据给定的格式字符串来格式化时间。请注意：格式字符串必须是常量表达式，例如：单个结果列不能有多种格式字符串
语法:formatDateTime(Time, Format [, Timezone])
返回值:根据指定格式返回的日期和时间

小示列：

select
  formatDateTime(toDate('2020-01-04'), '%D') as date
, formatDateTime(toDate('2020-01-04'), '%F')  as date_1
, formatDateTime(toDate('2021-05-13'), '%Y-%m-%d') as date_2
, formatDateTime(toDate('2021-05-13'), '%Y-%m')    as year_month;
 
select
  formatDateTime(toDateTime('2021-01-13 21:12:13'),'%Y-%m-%d %R:%S')        format_1-- %R24小时HH:MM时间，相当于%H:%M
, formatDateTime(toDateTime('2021-01-13 21:12:13'),'%Y-%m-%d %H:%M:%S')     format_2-- %H 24小时格式（00-23)
, formatDateTime(toDateTime('2021-01-13 21:12:13'),'%Y-%m-%d %I:%M:%S')     format_3-- %I 小时12h格式（01-12)
, formatDateTime(toDateTime('2021-01-13 21:12:13'),'%Y-%m-%d %p %I:%M:%S')  format_4;        -- %p 指定AM或PM

支持的格式修饰符如下： 

Placeholder	Description	Example
%C	year divided by 100 and truncated to integer (00-99)	20
%d	day of the month, zero-padded (01-31)	02
%D	Short MM/DD/YY date, equivalent to %m/%d/%y	01/02/18
%e	day of the month, space-padded ( 1-31)	2
%F	short YYYY-MM-DD date, equivalent to %Y-%m-%d	2018-01-02
%G	four-digit year format for ISO week number, calculated from the week-based year defined by the ISO 8601 standard, normally useful only with %V	2018
%g	two-digit year format, aligned to ISO 8601, abbreviated from four-digit notation	18
%H	hour in 24h format (00-23)	22
%I	hour in 12h format (01-12)	10
%j	day of the year (001-366)	002
%m	month as a decimal number (01-12)	01
%M	minute (00-59)	33
%n	new-line character (‘’)
%p	AM or PM designation	PM
%Q	Quarter (1-4)	1
%R	24-hour HH:MM time, equivalent to %H:%M	22:33
%S	second (00-59)	44
%t	horizontal-tab character (’)
%T	ISO 8601 time format (HH:MM:SS), equivalent to %H:%M:%S	22:33:44
%u	ISO 8601 weekday as number with Monday as 1 (1-7)	2
%V	ISO 8601 week number (01-53)	01
%w	weekday as a decimal number with Sunday as 0 (0-6)	2
%y	Year, last two digits (00-99)	18
%Y	Year	2018
%z	Time offset from UTC as +HHMM or -HHMM	-0500
%%	a % sign	%

参考：https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#formatdatetime

补充一个全球时区字符串的聚合地址，可随时查阅：

Country Code	Country Name	Time Zone	GMT Offset
AF	Afghanistan	Asia/Kabul	UTC +04:36
AL	Albania	Europe/Tirane	UTC +01:19
DZ	Algeria	Africa/Algiers	UTC +00:12
AS	American Samoa	Pacific/Pago_Pago	UTC +12:37
AD	Andorra	Europe/Andorra	UTC +00:06
AO	Angola	Africa/Luanda	UTC +00:13
AI	Anguilla	America/Anguilla	UTC -04:24
AQ	Antarctica	Antarctica/Casey	UTC
AQ	Antarctica	Antarctica/Davis	UTC
AQ	Antarctica	Antarctica/DumontDUrville	UTC +09:48
AQ	Antarctica	Antarctica/Mawson	UTC
AQ	Antarctica	Antarctica/McMurdo	UTC +11:39
AQ	Antarctica	Antarctica/Palmer	UTC
AQ	Antarctica	Antarctica/Rothera	UTC
AQ	Antarctica	Antarctica/Syowa	UTC +03:06
AQ	Antarctica	Antarctica/Troll	UTC
AQ	Antarctica	Antarctica/Vostok	UTC +05:50
AG	Antigua and Barbuda	America/Antigua	UTC -04:24
AR	Argentina	America/Argentina/Buenos_Aires	UTC -03:53
AR	Argentina	America/Argentina/Catamarca	UTC -04:23
AR	Argentina	America/Argentina/Cordoba	UTC -04:16
AR	Argentina	America/Argentina/Jujuy	UTC -04:21
AR	Argentina	America/Argentina/La_Rioja	UTC -04:27
AR	Argentina	America/Argentina/Mendoza	UTC -04:35
AR	Argentina	America/Argentina/Rio_Gallegos	UTC -04:36
AR	Argentina	America/Argentina/Salta	UTC -04:21
AR	Argentina	America/Argentina/San_Juan	UTC -04:34
AR	Argentina	America/Argentina/San_Luis	UTC -04:25
AR	Argentina	America/Argentina/Tucuman	UTC -04:20
AR	Argentina	America/Argentina/Ushuaia	UTC -04:33
AM	Armenia	Asia/Yerevan	UTC +02:58
AW	Aruba	America/Aruba	UTC -04:24
AU	Australia	Antarctica/Macquarie	UTC
AU	Australia	Australia/Adelaide	UTC +09:14
AU	Australia	Australia/Brisbane	UTC +10:12
AU	Australia	Australia/Broken_Hill	UTC +09:25
AU	Australia	Australia/Darwin	UTC +08:43
AU	Australia	Australia/Eucla	UTC +08:35
AU	Australia	Australia/Hobart	UTC +09:49
AU	Australia	Australia/Lindeman	UTC +09:55
AU	Australia	Australia/Lord_Howe	UTC +10:36
AU	Australia	Australia/Melbourne	UTC +09:39
AU	Australia	Australia/Perth	UTC +07:43
AU	Australia	Australia/Sydney	UTC +10:04
AT	Austria	Europe/Vienna	UTC +01:05
AZ	Azerbaijan	Asia/Baku	UTC +03:19
BS	Bahamas	America/Nassau	UTC -05:17
BH	Bahrain	Asia/Bahrain	UTC +03:26
BD	Bangladesh	Asia/Dhaka	UTC +06:01
BB	Barbados	America/Barbados	UTC -03:58
BY	Belarus	Europe/Minsk	UTC +01:50
BE	Belgium	Europe/Brussels	UTC +00:17
BZ	Belize	America/Belize	UTC -05:52
BJ	Benin	Africa/Porto-Novo	UTC +00:13
BM	Bermuda	Atlantic/Bermuda	UTC -04:19
BT	Bhutan	Asia/Thimphu	UTC +05:58
BO	Bolivia, Plurinational State of	America/La_Paz	UTC -04:32
BQ	Bonaire, Sint Eustatius and Saba	America/Kralendijk	UTC -04:24
BA	Bosnia and Herzegovina	Europe/Sarajevo	UTC +01:22
BW	Botswana	Africa/Gaborone	UTC +02:10
BR	Brazil	America/Araguaina	UTC -03:12
BR	Brazil	America/Bahia	UTC -02:34
BR	Brazil	America/Belem	UTC -03:13
BR	Brazil	America/Boa_Vista	UTC -04:02
BR	Brazil	America/Campo_Grande	UTC -03:38
BR	Brazil	America/Cuiaba	UTC -03:44
BR	Brazil	America/Eirunepe	UTC -04:39
BR	Brazil	America/Fortaleza	UTC -02:34
BR	Brazil	America/Maceio	UTC -02:22
BR	Brazil	America/Manaus	UTC -04:00
BR	Brazil	America/Noronha	UTC -02:09
BR	Brazil	America/Porto_Velho	UTC -04:15
BR	Brazil	America/Recife	UTC -02:19
BR	Brazil	America/Rio_Branco	UTC -04:31
BR	Brazil	America/Santarem	UTC -03:38
BR	Brazil	America/Sao_Paulo	UTC -03:06
IO	British Indian Ocean Territory	Indian/Chagos	UTC +04:49
BN	Brunei Darussalam	Asia/Brunei	UTC +07:21
BG	Bulgaria	Europe/Sofia	UTC +01:33
BF	Burkina Faso	Africa/Ouagadougou	UTC -00:16
BI	Burundi	Africa/Bujumbura	UTC +02:10
KH	Cambodia	Asia/Phnom_Penh	UTC +06:42
CM	Cameroon	Africa/Douala	UTC +00:13
CA	Canada	America/Atikokan	UTC -05:18
CA	Canada	America/Blanc-Sablon	UTC -04:24
CA	Canada	America/Cambridge_Bay	UTC
CA	Canada	America/Creston	UTC -07:28
CA	Canada	America/Dawson	UTC -09:17
CA	Canada	America/Dawson_Creek	UTC -08:00
CA	Canada	America/Edmonton	UTC -07:33
CA	Canada	America/Fort_Nelson	UTC -08:10
CA	Canada	America/Glace_Bay	UTC -03:59
CA	Canada	America/Goose_Bay	UTC -04:01
CA	Canada	America/Halifax	UTC -04:14
CA	Canada	America/Inuvik	UTC
CA	Canada	America/Iqaluit	UTC
CA	Canada	America/Moncton	UTC -04:19
CA	Canada	America/Nipigon	UTC -05:53
CA	Canada	America/Pangnirtung	UTC
CA	Canada	America/Rainy_River	UTC -06:18
CA	Canada	America/Rankin_Inlet	UTC
CA	Canada	America/Regina	UTC -06:58
CA	Canada	America/Resolute	UTC
CA	Canada	America/St_Johns	UTC -03:30
CA	Canada	America/Swift_Current	UTC -07:11
CA	Canada	America/Thunder_Bay	UTC -05:57
CA	Canada	America/Toronto	UTC -05:17
CA	Canada	America/Vancouver	UTC -08:12
CA	Canada	America/Whitehorse	UTC -09:00
CA	Canada	America/Winnipeg	UTC -06:28
CA	Canada	America/Yellowknife	UTC
CV	Cape Verde	Atlantic/Cape_Verde	UTC -01:34
KY	Cayman Islands	America/Cayman	UTC -05:18
CF	Central African Republic	Africa/Bangui	UTC +00:13
TD	Chad	Africa/Ndjamena	UTC +01:00
CL	Chile	America/Punta_Arenas	UTC -04:43
CL	Chile	America/Santiago	UTC -04:42
CL	Chile	Pacific/Easter	UTC -07:17
CN	China	Asia/Shanghai	UTC +08:05
CN	China	Asia/Urumqi	UTC +05:50
CX	Christmas Island	Indian/Christmas	UTC +06:42
CC	Cocos (Keeling) Islands	Indian/Cocos	UTC +06:24
CO	Colombia	America/Bogota	UTC -04:56
KM	Comoros	Indian/Comoro	UTC +02:27
CG	Congo	Africa/Brazzaville	UTC +00:13
CD	Congo, the Democratic Republic of the	Africa/Kinshasa	UTC +00:13
CD	Congo, the Democratic Republic of the	Africa/Lubumbashi	UTC +02:10
CK	Cook Islands	Pacific/Rarotonga	UTC +13:20
CR	Costa Rica	America/Costa_Rica	UTC -05:36
HR	Croatia	Europe/Zagreb	UTC +01:22
CU	Cuba	America/Havana	UTC -05:29
CW	Curaçao	America/Curacao	UTC -04:24
CY	Cyprus	Asia/Famagusta	UTC +02:15
CY	Cyprus	Asia/Nicosia	UTC +02:13
CZ	Czech Republic	Europe/Prague	UTC +00:57
CI	Côte d'Ivoire	Africa/Abidjan	UTC -00:16
DK	Denmark	Europe/Copenhagen	UTC +00:53
DJ	Djibouti	Africa/Djibouti	UTC +02:27
DM	Dominica	America/Dominica	UTC -04:24
DO	Dominican Republic	America/Santo_Domingo	UTC -04:39
EC	Ecuador	America/Guayaquil	UTC -05:19
EC	Ecuador	Pacific/Galapagos	UTC -05:58
EG	Egypt	Africa/Cairo	UTC +02:05
SV	El Salvador	America/El_Salvador	UTC -05:56
GQ	Equatorial Guinea	Africa/Malabo	UTC +00:13
ER	Eritrea	Africa/Asmara	UTC +02:27
EE	Estonia	Europe/Tallinn	UTC +01:39
ET	Ethiopia	Africa/Addis_Ababa	UTC +02:27
FK	Falkland Islands (Malvinas)	Atlantic/Stanley	UTC -03:51
FO	Faroe Islands	Atlantic/Faroe	UTC -00:27
FJ	Fiji	Pacific/Fiji	UTC +11:55
FI	Finland	Europe/Helsinki	UTC +01:39
FR	France	Europe/Paris	UTC +00:09
GF	French Guiana	America/Cayenne	UTC -03:29
PF	French Polynesia	Pacific/Gambier	UTC -08:59
PF	French Polynesia	Pacific/Marquesas	UTC -09:18
PF	French Polynesia	Pacific/Tahiti	UTC -09:58
TF	French Southern Territories	Indian/Kerguelen	UTC +04:54
GA	Gabon	Africa/Libreville	UTC +00:13
GM	Gambia	Africa/Banjul	UTC -00:16
GE	Georgia	Asia/Tbilisi	UTC +02:59
DE	Germany	Europe/Berlin	UTC +00:53
DE	Germany	Europe/Busingen	UTC +00:34
GH	Ghana	Africa/Accra	UTC -00:16
GI	Gibraltar	Europe/Gibraltar	UTC -00:21
GR	Greece	Europe/Athens	UTC +01:34
GL	Greenland	America/Danmarkshavn	UTC -01:14
GL	Greenland	America/Nuuk	UTC -03:26
GL	Greenland	America/Scoresbysund	UTC -01:27
GL	Greenland	America/Thule	UTC -04:35
GD	Grenada	America/Grenada	UTC -04:24
GP	Guadeloupe	America/Guadeloupe	UTC -04:24
GU	Guam	Pacific/Guam	UTC -14:21
GT	Guatemala	America/Guatemala	UTC -06:02
GG	Guernsey	Europe/Guernsey	UTC -00:01
GN	Guinea	Africa/Conakry	UTC -00:16
GW	Guinea-Bissau	Africa/Bissau	UTC -01:02
GY	Guyana	America/Guyana	UTC -03:52
HT	Haiti	America/Port-au-Prince	UTC -04:49
VA	Holy See (Vatican City State)	Europe/Vatican	UTC +00:49
HN	Honduras	America/Tegucigalpa	UTC -05:48
HK	Hong Kong	Asia/Hong_Kong	UTC +07:36
HU	Hungary	Europe/Budapest	UTC +01:16
IS	Iceland	Atlantic/Reykjavik	UTC -00:16
IN	India	Asia/Kolkata	UTC +05:53
ID	Indonesia	Asia/Jakarta	UTC +07:07
ID	Indonesia	Asia/Jayapura	UTC +09:22
ID	Indonesia	Asia/Makassar	UTC +07:57
ID	Indonesia	Asia/Pontianak	UTC +07:17
IR	Iran, Islamic Republic of	Asia/Tehran	UTC +03:25
IQ	Iraq	Asia/Baghdad	UTC +02:57
IE	Ireland	Europe/Dublin	UTC -00:25
IM	Isle of Man	Europe/Isle_of_Man	UTC -00:01
IL	Israel	Asia/Jerusalem	UTC +02:20
IT	Italy	Europe/Rome	UTC +00:49
JM	Jamaica	America/Jamaica	UTC -05:07
JP	Japan	Asia/Tokyo	UTC +09:18
JE	Jersey	Europe/Jersey	UTC -00:01
JO	Jordan	Asia/Amman	UTC +02:23
KZ	Kazakhstan	Asia/Almaty	UTC +05:07
KZ	Kazakhstan	Asia/Aqtau	UTC +03:21
KZ	Kazakhstan	Asia/Aqtobe	UTC +03:48
KZ	Kazakhstan	Asia/Atyrau	UTC +03:27
KZ	Kazakhstan	Asia/Oral	UTC +03:25
KZ	Kazakhstan	Asia/Qostanay	UTC +04:14
KZ	Kazakhstan	Asia/Qyzylorda	UTC +04:21
KE	Kenya	Africa/Nairobi	UTC +02:27
KI	Kiribati	Pacific/Kanton	UTC
KI	Kiribati	Pacific/Kiritimati	UTC -10:29
KI	Kiribati	Pacific/Tarawa	UTC +11:32
KP	Korea, Democratic People's Republic of	Asia/Pyongyang	UTC +08:23
KR	Korea, Republic of	Asia/Seoul	UTC +08:27
KW	Kuwait	Asia/Kuwait	UTC +03:06
KG	Kyrgyzstan	Asia/Bishkek	UTC +04:58
LA	Lao People's Democratic Republic	Asia/Vientiane	UTC +06:42
LV	Latvia	Europe/Riga	UTC +01:36
LB	Lebanon	Asia/Beirut	UTC +02:22
LS	Lesotho	Africa/Maseru	UTC +01:52
LR	Liberia	Africa/Monrovia	UTC -00:43
LY	Libya	Africa/Tripoli	UTC +00:52
LI	Liechtenstein	Europe/Vaduz	UTC +00:34
LT	Lithuania	Europe/Vilnius	UTC +01:41
LU	Luxembourg	Europe/Luxembourg	UTC +00:17
MO	Macao	Asia/Macau	UTC +07:34
MK	Macedonia, the Former Yugoslav Republic of	Europe/Skopje	UTC +01:22
MG	Madagascar	Indian/Antananarivo	UTC +02:27
MW	Malawi	Africa/Blantyre	UTC +02:10
MY	Malaysia	Asia/Kuala_Lumpur	UTC +06:55
MY	Malaysia	Asia/Kuching	UTC +07:21
MV	Maldives	Indian/Maldives	UTC +04:54
ML	Mali	Africa/Bamako	UTC -00:16
MT	Malta	Europe/Malta	UTC +00:58
MH	Marshall Islands	Pacific/Kwajalein	UTC +11:09
MH	Marshall Islands	Pacific/Majuro	UTC +11:32
MQ	Martinique	America/Martinique	UTC -04:04
MR	Mauritania	Africa/Nouakchott	UTC -00:16
MU	Mauritius	Indian/Mauritius	UTC +03:50
YT	Mayotte	Indian/Mayotte	UTC +02:27
MX	Mexico	America/Bahia_Banderas	UTC -07:01
MX	Mexico	America/Cancun	UTC -05:47
MX	Mexico	America/Chihuahua	UTC -07:04
MX	Mexico	America/Hermosillo	UTC -07:23
MX	Mexico	America/Matamoros	UTC -06:40
MX	Mexico	America/Mazatlan	UTC -07:05
MX	Mexico	America/Merida	UTC -05:58
MX	Mexico	America/Mexico_City	UTC -06:36
MX	Mexico	America/Monterrey	UTC -06:41
MX	Mexico	America/Ojinaga	UTC -06:57
MX	Mexico	America/Tijuana	UTC -07:48
FM	Micronesia, Federated States of	Pacific/Chuuk	UTC +09:48
FM	Micronesia, Federated States of	Pacific/Kosrae	UTC -13:08
FM	Micronesia, Federated States of	Pacific/Pohnpei	UTC +10:39
MD	Moldova, Republic of	Europe/Chisinau	UTC +01:55
MC	Monaco	Europe/Monaco	UTC +00:09
MN	Mongolia	Asia/Choibalsan	UTC +07:38
MN	Mongolia	Asia/Hovd	UTC +06:06
MN	Mongolia	Asia/Ulaanbaatar	UTC +07:07
ME	Montenegro	Europe/Podgorica	UTC +01:22
MS	Montserrat	America/Montserrat	UTC -04:24
MA	Morocco	Africa/Casablanca	UTC -00:30
MA	Morocco	Africa/El_Aaiun	UTC -00:52
MZ	Mozambique	Africa/Maputo	UTC +02:10
MM	Myanmar	Asia/Yangon	UTC +06:24
NA	Namibia	Africa/Windhoek	UTC +01:08
NR	Nauru	Pacific/Nauru	UTC +11:07
NP	Nepal	Asia/Kathmandu	UTC +05:41
NL	Netherlands	Europe/Amsterdam	UTC +00:17
NC	New Caledonia	Pacific/Noumea	UTC +11:05
NZ	New Zealand	Pacific/Auckland	UTC +11:39
NZ	New Zealand	Pacific/Chatham	UTC +12:13
NI	Nicaragua	America/Managua	UTC -05:45
NE	Niger	Africa/Niamey	UTC +00:13
NG	Nigeria	Africa/Lagos	UTC +00:13
NU	Niue	Pacific/Niue	UTC -11:19
NF	Norfolk Island	Pacific/Norfolk	UTC +11:11
MP	Northern Mariana Islands	Pacific/Saipan	UTC -14:21
NO	Norway	Europe/Oslo	UTC +00:53
OM	Oman	Asia/Muscat	UTC +03:41
PK	Pakistan	Asia/Karachi	UTC +04:28
PW	Palau	Pacific/Palau	UTC -15:02
PS	Palestine, State of	Asia/Gaza	UTC +02:17
PS	Palestine, State of	Asia/Hebron	UTC +02:20
PA	Panama	America/Panama	UTC -05:18
PG	Papua New Guinea	Pacific/Bougainville	UTC +10:22
PG	Papua New Guinea	Pacific/Port_Moresby	UTC +09:48
PY	Paraguay	America/Asuncion	UTC -03:50
PE	Peru	America/Lima	UTC -05:08
PH	Philippines	Asia/Manila	UTC -15:56
PN	Pitcairn	Pacific/Pitcairn	UTC -08:40
PL	Poland	Europe/Warsaw	UTC +01:24
PT	Portugal	Atlantic/Azores	UTC -01:42
PT	Portugal	Atlantic/Madeira	UTC -01:07
PT	Portugal	Europe/Lisbon	UTC -00:36
PR	Puerto Rico	America/Puerto_Rico	UTC -04:24
QA	Qatar	Asia/Qatar	UTC +03:26
RO	Romania	Europe/Bucharest	UTC +01:44
RU	Russian Federation	Asia/Anadyr	UTC +11:49
RU	Russian Federation	Asia/Barnaul	UTC +05:35
RU	Russian Federation	Asia/Chita	UTC +07:33
RU	Russian Federation	Asia/Irkutsk	UTC +06:57
RU	Russian Federation	Asia/Kamchatka	UTC +10:34
RU	Russian Federation	Asia/Khandyga	UTC +09:02
RU	Russian Federation	Asia/Krasnoyarsk	UTC +06:11
RU	Russian Federation	Asia/Magadan	UTC +10:03
RU	Russian Federation	Asia/Novokuznetsk	UTC +05:48
RU	Russian Federation	Asia/Novosibirsk	UTC +05:31
RU	Russian Federation	Asia/Omsk	UTC +04:53
RU	Russian Federation	Asia/Sakhalin	UTC +09:30
RU	Russian Federation	Asia/Srednekolymsk	UTC +10:14
RU	Russian Federation	Asia/Tomsk	UTC +05:39
RU	Russian Federation	Asia/Ust-Nera	UTC +09:32
RU	Russian Federation	Asia/Vladivostok	UTC +08:47
RU	Russian Federation	Asia/Yakutsk	UTC +08:38
RU	Russian Federation	Asia/Yekaterinburg	UTC +04:02
RU	Russian Federation	Europe/Astrakhan	UTC +03:12
RU	Russian Federation	Europe/Kaliningrad	UTC +01:22
RU	Russian Federation	Europe/Kirov	UTC +03:18
RU	Russian Federation	Europe/Moscow	UTC +02:30
RU	Russian Federation	Europe/Samara	UTC +03:20
RU	Russian Federation	Europe/Saratov	UTC +03:04
RU	Russian Federation	Europe/Ulyanovsk	UTC +03:13
RU	Russian Federation	Europe/Volgograd	UTC +02:57
RW	Rwanda	Africa/Kigali	UTC +02:10
RE	Réunion	Indian/Reunion	UTC +03:41
BL	Saint Barthélemy	America/St_Barthelemy	UTC -04:24
SH	Saint Helena, Ascension and Tristan da Cunha	Atlantic/St_Helena	UTC -00:16
KN	Saint Kitts and Nevis	America/St_Kitts	UTC -04:24
LC	Saint Lucia	America/St_Lucia	UTC -04:24
MF	Saint Martin (French part)	America/Marigot	UTC -04:24
PM	Saint Pierre and Miquelon	America/Miquelon	UTC -03:44
VC	Saint Vincent and the Grenadines	America/St_Vincent	UTC -04:24
WS	Samoa	Pacific/Apia	UTC +12:33
SM	San Marino	Europe/San_Marino	UTC +00:49
ST	Sao Tome and Principe	Africa/Sao_Tome	UTC +00:26
SA	Saudi Arabia	Asia/Riyadh	UTC +03:06
SN	Senegal	Africa/Dakar	UTC -00:16
RS	Serbia	Europe/Belgrade	UTC +01:22
SC	Seychelles	Indian/Mahe	UTC +03:41
SL	Sierra Leone	Africa/Freetown	UTC -00:16
SG	Singapore	Asia/Singapore	UTC +06:55
SX	Sint Maarten (Dutch part)	America/Lower_Princes	UTC -04:24
SK	Slovakia	Europe/Bratislava	UTC +00:57
SI	Slovenia	Europe/Ljubljana	UTC +01:22
SB	Solomon Islands	Pacific/Guadalcanal	UTC +10:39
SO	Somalia	Africa/Mogadishu	UTC +02:27
ZA	South Africa	Africa/Johannesburg	UTC +01:52
GS	South Georgia and the South Sandwich Islands	Atlantic/South_Georgia	UTC -02:26
SS	South Sudan	Africa/Juba	UTC +02:06
ES	Spain	Africa/Ceuta	UTC -00:21
ES	Spain	Atlantic/Canary	UTC -01:01
ES	Spain	Europe/Madrid	UTC -00:14
LK	Sri Lanka	Asia/Colombo	UTC +05:19
SD	Sudan	Africa/Khartoum	UTC +02:10
SR	Suriname	America/Paramaribo	UTC -03:40
SJ	Svalbard and Jan Mayen	Arctic/Longyearbyen	UTC +00:53
SZ	Swaziland	Africa/Mbabane	UTC +01:52
SE	Sweden	Europe/Stockholm	UTC +00:53
CH	Switzerland	Europe/Zurich	UTC +00:34
SY	Syrian Arab Republic	Asia/Damascus	UTC +02:25
TW	Taiwan, Province of China	Asia/Taipei	UTC +08:06
TJ	Tajikistan	Asia/Dushanbe	UTC +04:35
TZ	Tanzania, United Republic of	Africa/Dar_es_Salaam	UTC +02:27
TH	Thailand	Asia/Bangkok	UTC +06:42
TL	Timor-Leste	Asia/Dili	UTC +08:22
TG	Togo	Africa/Lome	UTC -00:16
TK	Tokelau	Pacific/Fakaofo	UTC -11:24
TO	Tonga	Pacific/Tongatapu	UTC +12:19
TT	Trinidad and Tobago	America/Port_of_Spain	UTC -04:24
TN	Tunisia	Africa/Tunis	UTC +00:40
TR	Turkey	Europe/Istanbul	UTC +01:55
TM	Turkmenistan	Asia/Ashgabat	UTC +03:53
TC	Turks and Caicos Islands	America/Grand_Turk	UTC -04:44
TV	Tuvalu	Pacific/Funafuti	UTC +11:32
UG	Uganda	Africa/Kampala	UTC +02:27
UA	Ukraine	Europe/Kyiv	UTC +02:02
UA	Ukraine	Europe/Simferopol	UTC +02:16
UA	Ukraine	Europe/Uzhgorod	UTC +01:29
UA	Ukraine	Europe/Zaporozhye	UTC +02:20
AE	United Arab Emirates	Asia/Dubai	UTC +03:41
GB	United Kingdom	Europe/London	UTC -00:01
US	United States	America/Adak	UTC +12:13
US	United States	America/Anchorage	UTC +14:00
US	United States	America/Boise	UTC -07:44
US	United States	America/Chicago	UTC -05:50
US	United States	America/Denver	UTC -06:59
US	United States	America/Detroit	UTC -05:32
US	United States	America/Indiana/Indianapolis	UTC -05:44
US	United States	America/Indiana/Knox	UTC -05:46
US	United States	America/Indiana/Marengo	UTC -05:45
US	United States	America/Indiana/Petersburg	UTC -05:49
US	United States	America/Indiana/Tell_City	UTC -05:47
US	United States	America/Indiana/Vevay	UTC -05:40
US	United States	America/Indiana/Vincennes	UTC -05:50
US	United States	America/Indiana/Winamac	UTC -05:46
US	United States	America/Juneau	UTC +15:02
US	United States	America/Kentucky/Louisville	UTC -05:43
US	United States	America/Kentucky/Monticello	UTC -05:39
US	United States	America/Los_Angeles	UTC -07:52
US	United States	America/Menominee	UTC -05:50
US	United States	America/Metlakatla	UTC +15:13
US	United States	America/New_York	UTC -04:56
US	United States	America/Nome	UTC +12:58
US	United States	America/North_Dakota/Beulah	UTC -06:47
US	United States	America/North_Dakota/Center	UTC -06:45
US	United States	America/North_Dakota/New_Salem	UTC -06:45
US	United States	America/Phoenix	UTC -07:28
US	United States	America/Sitka	UTC +14:58
US	United States	America/Yakutat	UTC +14:41
US	United States	Pacific/Honolulu	UTC -10:31
UM	United States Minor Outlying Islands	Pacific/Midway	UTC +12:37
UM	United States Minor Outlying Islands	Pacific/Wake	UTC +11:32
UY	Uruguay	America/Montevideo	UTC -03:44
UZ	Uzbekistan	Asia/Samarkand	UTC +04:27
UZ	Uzbekistan	Asia/Tashkent	UTC +04:37
VU	Vanuatu	Pacific/Efate	UTC +11:13
VE	Venezuela, Bolivarian Republic of	America/Caracas	UTC -04:27
VN	Viet Nam	Asia/Ho_Chi_Minh	UTC +07:06
VG	Virgin Islands, British	America/Tortola	UTC -04:24
VI	Virgin Islands, U.S.	America/St_Thomas	UTC -04:24
WF	Wallis and Futuna	Pacific/Wallis	UTC +11:32
YE	Yemen	Asia/Aden	UTC +03:06
ZM	Zambia	Africa/Lusaka	UTC +02:10
ZW	Zimbabwe	Africa/Harare	UTC +02:10
AX	Åland Islands	Europe/Mariehamn	UTC +01:39