Skip to content

Instantly share code, notes, and snippets.

@filimonov

filimonov/datatimetest.reference

Last active August 14, 2020 11:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save filimonov/6b27dca3b274801f86b27f7daf5ab9f8 to your computer and use it in GitHub Desktop.
Save filimonov/6b27dca3b274801f86b27f7daf5ab9f8 to your computer and use it in GitHub Desktop.
Download ZIP
clickhouse timezones check
Raw
datatimetest.reference
Africa/Juba (73475999,'1972-04-30 12:59:59','1972-04-30 11:59:59')
Africa/Juba (73476000,'1972-04-30 13:00:00','1972-04-30 12:00:00')
Africa/Juba (73476001,'1972-04-30 13:00:01','1972-04-30 12:00:01')
Africa/Juba (325666799,'1980-04-27 09:59:59','1980-04-27 08:59:59')
Africa/Juba (325666800,'1980-04-27 10:00:00','1980-04-27 09:00:00')
Africa/Juba (325666801,'1980-04-27 10:00:01','1980-04-27 09:00:01')
Africa/Juba (388566009,'1982-04-25 10:00:09','1982-04-25 09:00:09')
Africa/Juba (388566010,'1982-04-25 10:00:10','1982-04-25 09:00:10')
Africa/Juba (388566011,'1982-04-25 10:00:11','1982-04-25 09:00:11')
Africa/Khartoum (73475999,'1972-04-30 12:59:59','1972-04-30 11:59:59')
Africa/Khartoum (73476000,'1972-04-30 13:00:00','1972-04-30 12:00:00')
Africa/Khartoum (73476001,'1972-04-30 13:00:01','1972-04-30 12:00:01')
Africa/Khartoum (325666799,'1980-04-27 09:59:59','1980-04-27 08:59:59')
Africa/Khartoum (325666800,'1980-04-27 10:00:00','1980-04-27 09:00:00')
Africa/Khartoum (325666801,'1980-04-27 10:00:01','1980-04-27 09:00:01')
Africa/Khartoum (388566009,'1982-04-25 10:00:09','1982-04-25 09:00:09')
Africa/Khartoum (388566010,'1982-04-25 10:00:10','1982-04-25 09:00:10')
Africa/Khartoum (388566011,'1982-04-25 10:00:11','1982-04-25 09:00:11')
Africa/Monrovia (9961200,'1970-04-26 06:16:00','1970-04-26 06:15:00')
Africa/Monrovia (9961201,'1970-04-26 06:16:01','1970-04-26 06:15:01')
America/Araguaina (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Araguaina (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Araguaina (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Buenos_Aires (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Buenos_Aires (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Buenos_Aires (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Catamarca (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Catamarca (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Catamarca (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/ComodRivadavia (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/ComodRivadavia (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/ComodRivadavia (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Cordoba (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Cordoba (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Cordoba (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Jujuy (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Jujuy (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Jujuy (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/La_Rioja (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/La_Rioja (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/La_Rioja (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Mendoza (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Mendoza (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Mendoza (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Rio_Gallegos (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Rio_Gallegos (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Rio_Gallegos (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Salta (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Salta (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Salta (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/San_Juan (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/San_Juan (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/San_Juan (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/San_Luis (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/San_Luis (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/San_Luis (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Tucuman (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Tucuman (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Tucuman (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Argentina/Ushuaia (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Argentina/Ushuaia (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Argentina/Ushuaia (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Bahia (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Bahia (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Bahia (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Buenos_Aires (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Buenos_Aires (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Buenos_Aires (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Catamarca (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Catamarca (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Catamarca (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Cordoba (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Cordoba (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Cordoba (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Fortaleza (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Fortaleza (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Fortaleza (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Havana (9961199,'1970-04-26 02:59:59','1970-04-26 01:59:59')
America/Havana (9961200,'1970-04-26 03:00:00','1970-04-26 02:00:00')
America/Havana (9961201,'1970-04-26 03:00:01','1970-04-26 02:00:01')
America/Havana (73475999,'1972-04-30 05:59:59','1972-04-30 04:59:59')
America/Havana (73476000,'1972-04-30 06:00:00','1972-04-30 05:00:00')
America/Havana (73476001,'1972-04-30 06:00:01','1972-04-30 05:00:01')
America/Havana (671011199,'1991-04-07 03:59:59','1991-04-07 02:59:59')
America/Havana (671011200,'1991-04-07 04:00:00','1991-04-07 03:00:00')
America/Havana (671011201,'1991-04-07 04:00:01','1991-04-07 03:00:01')
America/Havana (1018173599,'2002-04-07 05:59:59','2002-04-07 04:59:59')
America/Havana (1018173600,'2002-04-07 06:00:00','2002-04-07 05:00:00')
America/Havana (1018173601,'2002-04-07 06:00:01','2002-04-07 05:00:01')
America/Havana (1236495623,'2009-03-08 03:00:23','2009-03-08 02:00:23')
America/Havana (1236495624,'2009-03-08 03:00:24','2009-03-08 02:00:24')
America/Havana (1236495625,'2009-03-08 03:00:25','2009-03-08 02:00:25')
America/Havana (1425798024,'2015-03-08 03:00:24','2015-03-08 02:00:24')
America/Havana (1425798025,'2015-03-08 03:00:25','2015-03-08 02:00:25')
America/Havana (1425798026,'2015-03-08 03:00:26','2015-03-08 02:00:26')
America/Jujuy (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Jujuy (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Jujuy (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Maceio (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Maceio (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Maceio (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Mendoza (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Mendoza (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Mendoza (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Noronha (624423613,'1989-10-15 02:00:13','1989-10-15 01:00:13')
America/Noronha (624423614,'1989-10-15 02:00:14','1989-10-15 01:00:14')
America/Noronha (624423615,'1989-10-15 02:00:15','1989-10-15 01:00:15')
America/Recife (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Recife (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Recife (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Rosario (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Rosario (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Rosario (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Sao_Paulo (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
America/Sao_Paulo (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
America/Sao_Paulo (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
America/Scoresbysund (386125200,'1982-03-28 01:00:00','1982-03-28 00:00:00')
America/Scoresbysund (386125201,'1982-03-28 01:00:01','1982-03-28 00:00:01')
America/Scoresbysund (417574810,'1983-03-27 01:00:10','1983-03-27 00:00:10')
America/Scoresbysund (417574811,'1983-03-27 01:00:11','1983-03-27 00:00:11')
America/Scoresbysund (417574812,'1983-03-27 01:00:12','1983-03-27 00:00:12')
America/Scoresbysund (859683600,'1997-03-30 01:00:00','1997-03-30 00:00:00')
America/Scoresbysund (859683601,'1997-03-30 01:00:01','1997-03-30 00:00:01')
America/Scoresbysund (922582800,'1999-03-28 01:00:00','1999-03-28 00:00:00')
America/Scoresbysund (922582801,'1999-03-28 01:00:01','1999-03-28 00:00:01')
America/Scoresbysund (1143334800,'2006-03-26 01:00:00','2006-03-26 00:00:00')
America/Scoresbysund (1143334801,'2006-03-26 01:00:01','2006-03-26 00:00:01')
America/Scoresbysund (1174784400,'2007-03-25 01:00:00','2007-03-25 00:00:00')
America/Scoresbysund (1174784401,'2007-03-25 01:00:01','2007-03-25 00:00:01')
America/Scoresbysund (1206838822,'2008-03-30 01:00:22','2008-03-30 00:00:22')
America/Scoresbysund (1206838823,'2008-03-30 01:00:23','2008-03-30 00:00:23')
America/Scoresbysund (1206838824,'2008-03-30 01:00:24','2008-03-30 00:00:24')
America/Scoresbysund (1459040400,'2016-03-27 01:00:00','2016-03-27 00:00:00')
America/Scoresbysund (1459040401,'2016-03-27 01:00:01','2016-03-27 00:00:01')
America/Scoresbysund (2090451626,'2036-03-30 01:00:26','2036-03-30 00:00:26')
America/Scoresbysund (2090451627,'2036-03-30 01:00:27','2036-03-30 00:00:27')
America/Scoresbysund (2090451628,'2036-03-30 01:00:28','2036-03-30 00:00:28')
Asia/Beirut (859683599,'1997-03-30 03:59:59','1997-03-30 02:59:59')
Asia/Beirut (859683600,'1997-03-30 04:00:00','1997-03-30 03:00:00')
Asia/Beirut (859683601,'1997-03-30 04:00:01','1997-03-30 03:00:01')
Asia/Beirut (922582799,'1999-03-28 03:59:59','1999-03-28 02:59:59')
Asia/Beirut (922582800,'1999-03-28 04:00:00','1999-03-28 03:00:00')
Asia/Beirut (922582801,'1999-03-28 04:00:01','1999-03-28 03:00:01')
Asia/Beirut (1143334799,'2006-03-26 03:59:59','2006-03-26 02:59:59')
Asia/Beirut (1143334800,'2006-03-26 04:00:00','2006-03-26 03:00:00')
Asia/Beirut (1143334801,'2006-03-26 04:00:01','2006-03-26 03:00:01')
Asia/Beirut (1174784399,'2007-03-25 03:59:59','2007-03-25 02:59:59')
Asia/Beirut (1174784400,'2007-03-25 04:00:00','2007-03-25 03:00:00')
Asia/Beirut (1174784401,'2007-03-25 04:00:01','2007-03-25 03:00:01')
Asia/Beirut (1206838822,'2008-03-30 04:00:22','2008-03-30 03:00:22')
Asia/Beirut (1206838823,'2008-03-30 04:00:23','2008-03-30 03:00:23')
Asia/Beirut (1206838824,'2008-03-30 04:00:24','2008-03-30 03:00:24')
Asia/Beirut (1459040399,'2016-03-27 03:59:59','2016-03-27 02:59:59')
Asia/Beirut (1459040400,'2016-03-27 04:00:00','2016-03-27 03:00:00')
Asia/Beirut (1459040401,'2016-03-27 04:00:01','2016-03-27 03:00:01')
Asia/Beirut (2090451626,'2036-03-30 04:00:26','2036-03-30 03:00:26')
Asia/Beirut (2090451627,'2036-03-30 04:00:27','2036-03-30 03:00:27')
Asia/Beirut (2090451628,'2036-03-30 04:00:28','2036-03-30 03:00:28')
Asia/Choibalsan (859683599,'1997-03-30 10:59:59','1997-03-30 09:59:59')
Asia/Choibalsan (859683600,'1997-03-30 11:00:00','1997-03-30 10:00:00')
Asia/Choibalsan (859683601,'1997-03-30 11:00:01','1997-03-30 10:00:01')
Asia/Famagusta (354675599,'1981-03-29 03:59:59','1981-03-29 02:59:59')
Asia/Famagusta (354675600,'1981-03-29 04:00:00','1981-03-29 03:00:00')
Asia/Famagusta (354675601,'1981-03-29 04:00:01','1981-03-29 03:00:01')
Asia/Famagusta (386125199,'1982-03-28 03:59:59','1982-03-28 02:59:59')
Asia/Famagusta (386125200,'1982-03-28 04:00:00','1982-03-28 03:00:00')
Asia/Famagusta (386125201,'1982-03-28 04:00:01','1982-03-28 03:00:01')
Asia/Famagusta (417574810,'1983-03-27 04:00:10','1983-03-27 03:00:10')
Asia/Famagusta (417574811,'1983-03-27 04:00:11','1983-03-27 03:00:11')
Asia/Famagusta (417574812,'1983-03-27 04:00:12','1983-03-27 03:00:12')
Asia/Famagusta (859683599,'1997-03-30 03:59:59','1997-03-30 02:59:59')
Asia/Famagusta (859683600,'1997-03-30 04:00:00','1997-03-30 03:00:00')
Asia/Famagusta (859683601,'1997-03-30 04:00:01','1997-03-30 03:00:01')
Asia/Hovd (859683599,'1997-03-30 08:59:59','1997-03-30 07:59:59')
Asia/Hovd (859683600,'1997-03-30 09:00:00','1997-03-30 08:00:00')
Asia/Hovd (859683601,'1997-03-30 09:00:01','1997-03-30 08:00:01')
Asia/Karachi (1018173599,'2002-04-07 15:59:59','2002-04-07 14:59:59')
Asia/Karachi (1018173600,'2002-04-07 16:00:00','2002-04-07 15:00:00')
Asia/Karachi (1018173601,'2002-04-07 16:00:01','2002-04-07 15:00:01')
Asia/Nicosia (354675599,'1981-03-29 03:59:59','1981-03-29 02:59:59')
Asia/Nicosia (354675600,'1981-03-29 04:00:00','1981-03-29 03:00:00')
Asia/Nicosia (354675601,'1981-03-29 04:00:01','1981-03-29 03:00:01')
Asia/Nicosia (386125199,'1982-03-28 03:59:59','1982-03-28 02:59:59')
Asia/Nicosia (386125200,'1982-03-28 04:00:00','1982-03-28 03:00:00')
Asia/Nicosia (386125201,'1982-03-28 04:00:01','1982-03-28 03:00:01')
Asia/Nicosia (417574810,'1983-03-27 04:00:10','1983-03-27 03:00:10')
Asia/Nicosia (417574811,'1983-03-27 04:00:11','1983-03-27 03:00:11')
Asia/Nicosia (417574812,'1983-03-27 04:00:12','1983-03-27 03:00:12')
Asia/Nicosia (859683599,'1997-03-30 03:59:59','1997-03-30 02:59:59')
Asia/Nicosia (859683600,'1997-03-30 04:00:00','1997-03-30 03:00:00')
Asia/Nicosia (859683601,'1997-03-30 04:00:01','1997-03-30 03:00:01')
Asia/Tbilisi (922582799,'1999-03-28 05:59:59','1999-03-28 04:59:59')
Asia/Tbilisi (922582800,'1999-03-28 06:00:00','1999-03-28 05:00:00')
Asia/Tbilisi (922582801,'1999-03-28 06:00:01','1999-03-28 05:00:01')
Asia/Ulaanbaatar (859683599,'1997-03-30 09:59:59','1997-03-30 08:59:59')
Asia/Ulaanbaatar (859683600,'1997-03-30 10:00:00','1997-03-30 09:00:00')
Asia/Ulaanbaatar (859683601,'1997-03-30 10:00:01','1997-03-30 09:00:01')
Asia/Ulan_Bator (859683599,'1997-03-30 09:59:59','1997-03-30 08:59:59')
Asia/Ulan_Bator (859683600,'1997-03-30 10:00:00','1997-03-30 09:00:00')
Asia/Ulan_Bator (859683601,'1997-03-30 10:00:01','1997-03-30 09:00:01')
Atlantic/Azores (859683600,'1997-03-30 01:00:00','1997-03-30 00:00:00')
Atlantic/Azores (859683601,'1997-03-30 01:00:01','1997-03-30 00:00:01')
Atlantic/Azores (922582800,'1999-03-28 01:00:00','1999-03-28 00:00:00')
Atlantic/Azores (922582801,'1999-03-28 01:00:01','1999-03-28 00:00:01')
Atlantic/Azores (1143334800,'2006-03-26 01:00:00','2006-03-26 00:00:00')
Atlantic/Azores (1143334801,'2006-03-26 01:00:01','2006-03-26 00:00:01')
Atlantic/Azores (1174784400,'2007-03-25 01:00:00','2007-03-25 00:00:00')
Atlantic/Azores (1174784401,'2007-03-25 01:00:01','2007-03-25 00:00:01')
Atlantic/Azores (1206838822,'2008-03-30 01:00:22','2008-03-30 00:00:22')
Atlantic/Azores (1206838823,'2008-03-30 01:00:23','2008-03-30 00:00:23')
Atlantic/Azores (1206838824,'2008-03-30 01:00:24','2008-03-30 00:00:24')
Atlantic/Azores (1459040400,'2016-03-27 01:00:00','2016-03-27 00:00:00')
Atlantic/Azores (1459040401,'2016-03-27 01:00:01','2016-03-27 00:00:01')
Atlantic/Azores (2090451626,'2036-03-30 01:00:26','2036-03-30 00:00:26')
Atlantic/Azores (2090451627,'2036-03-30 01:00:27','2036-03-30 00:00:27')
Atlantic/Azores (2090451628,'2036-03-30 01:00:28','2036-03-30 00:00:28')
Australia/LHI (636516014,'1990-03-04 12:30:14','1990-03-04 12:00:14')
Australia/LHI (636516015,'1990-03-04 12:30:15','1990-03-04 12:00:15')
Australia/LHI (636516016,'1990-03-04 12:30:16','1990-03-04 12:00:16')
Australia/LHI (752047217,'1993-10-31 17:00:17','1993-10-31 17:30:17')
Australia/LHI (752047218,'1993-10-31 17:00:18','1993-10-31 17:30:18')
Australia/LHI (752047219,'1993-10-31 17:00:19','1993-10-31 17:30:19')
Australia/LHI (859683599,'1997-03-30 11:29:59','1997-03-30 11:59:59')
Australia/LHI (859683600,'1997-03-30 11:30:00','1997-03-30 11:00:00')
Australia/LHI (859683601,'1997-03-30 11:30:01','1997-03-30 11:00:01')
Australia/LHI (922582799,'1999-03-28 11:29:59','1999-03-28 11:59:59')
Australia/LHI (922582800,'1999-03-28 11:30:00','1999-03-28 11:00:00')
Australia/LHI (922582801,'1999-03-28 11:30:01','1999-03-28 11:00:01')
Australia/LHI (1035705599,'2002-10-27 18:59:59','2002-10-27 18:29:59')
Australia/LHI (1035705600,'2002-10-27 19:00:00','2002-10-27 19:30:00')
Australia/LHI (1035705601,'2002-10-27 19:00:01','2002-10-27 19:30:01')
Australia/LHI (1162105222,'2006-10-29 18:00:22','2006-10-29 18:30:22')
Australia/LHI (1162105223,'2006-10-29 18:00:23','2006-10-29 18:30:23')
Australia/LHI (1162105224,'2006-10-29 18:00:24','2006-10-29 18:30:24')
Australia/LHI (1174784399,'2007-03-25 11:29:59','2007-03-25 11:59:59')
Australia/LHI (1174784400,'2007-03-25 11:30:00','2007-03-25 11:00:00')
Australia/LHI (1174784401,'2007-03-25 11:30:01','2007-03-25 11:00:01')
Australia/Lord_Howe (636516014,'1990-03-04 12:30:14','1990-03-04 12:00:14')
Australia/Lord_Howe (636516015,'1990-03-04 12:30:15','1990-03-04 12:00:15')
Australia/Lord_Howe (636516016,'1990-03-04 12:30:16','1990-03-04 12:00:16')
Australia/Lord_Howe (752047217,'1993-10-31 17:00:17','1993-10-31 17:30:17')
Australia/Lord_Howe (752047218,'1993-10-31 17:00:18','1993-10-31 17:30:18')
Australia/Lord_Howe (752047219,'1993-10-31 17:00:19','1993-10-31 17:30:19')
Australia/Lord_Howe (859683599,'1997-03-30 11:29:59','1997-03-30 11:59:59')
Australia/Lord_Howe (859683600,'1997-03-30 11:30:00','1997-03-30 11:00:00')
Australia/Lord_Howe (859683601,'1997-03-30 11:30:01','1997-03-30 11:00:01')
Australia/Lord_Howe (922582799,'1999-03-28 11:29:59','1999-03-28 11:59:59')
Australia/Lord_Howe (922582800,'1999-03-28 11:30:00','1999-03-28 11:00:00')
Australia/Lord_Howe (922582801,'1999-03-28 11:30:01','1999-03-28 11:00:01')
Australia/Lord_Howe (1035705599,'2002-10-27 18:59:59','2002-10-27 18:29:59')
Australia/Lord_Howe (1035705600,'2002-10-27 19:00:00','2002-10-27 19:30:00')
Australia/Lord_Howe (1035705601,'2002-10-27 19:00:01','2002-10-27 19:30:01')
Australia/Lord_Howe (1162105222,'2006-10-29 18:00:22','2006-10-29 18:30:22')
Australia/Lord_Howe (1162105223,'2006-10-29 18:00:23','2006-10-29 18:30:23')
Australia/Lord_Howe (1162105224,'2006-10-29 18:00:24','2006-10-29 18:30:24')
Australia/Lord_Howe (1174784399,'2007-03-25 11:29:59','2007-03-25 11:59:59')
Australia/Lord_Howe (1174784400,'2007-03-25 11:30:00','2007-03-25 11:00:00')
Australia/Lord_Howe (1174784401,'2007-03-25 11:30:01','2007-03-25 11:00:01')
Brazil/DeNoronha (624423613,'1989-10-15 02:00:13','1989-10-15 01:00:13')
Brazil/DeNoronha (624423614,'1989-10-15 02:00:14','1989-10-15 01:00:14')
Brazil/DeNoronha (624423615,'1989-10-15 02:00:15','1989-10-15 01:00:15')
Brazil/East (624423613,'1989-10-15 01:00:13','1989-10-15 00:00:13')
Brazil/East (624423614,'1989-10-15 01:00:14','1989-10-15 00:00:14')
Brazil/East (624423615,'1989-10-15 01:00:15','1989-10-15 00:00:15')
Cuba (9961199,'1970-04-26 02:59:59','1970-04-26 01:59:59')
Cuba (9961200,'1970-04-26 03:00:00','1970-04-26 02:00:00')
Cuba (9961201,'1970-04-26 03:00:01','1970-04-26 02:00:01')
Cuba (73475999,'1972-04-30 05:59:59','1972-04-30 04:59:59')
Cuba (73476000,'1972-04-30 06:00:00','1972-04-30 05:00:00')
Cuba (73476001,'1972-04-30 06:00:01','1972-04-30 05:00:01')
Cuba (671011199,'1991-04-07 03:59:59','1991-04-07 02:59:59')
Cuba (671011200,'1991-04-07 04:00:00','1991-04-07 03:00:00')
Cuba (671011201,'1991-04-07 04:00:01','1991-04-07 03:00:01')
Cuba (1018173599,'2002-04-07 05:59:59','2002-04-07 04:59:59')
Cuba (1018173600,'2002-04-07 06:00:00','2002-04-07 05:00:00')
Cuba (1018173601,'2002-04-07 06:00:01','2002-04-07 05:00:01')
Cuba (1236495623,'2009-03-08 03:00:23','2009-03-08 02:00:23')
Cuba (1236495624,'2009-03-08 03:00:24','2009-03-08 02:00:24')
Cuba (1236495625,'2009-03-08 03:00:25','2009-03-08 02:00:25')
Cuba (1425798024,'2015-03-08 03:00:24','2015-03-08 02:00:24')
Cuba (1425798025,'2015-03-08 03:00:25','2015-03-08 02:00:25')
Cuba (1425798026,'2015-03-08 03:00:26','2015-03-08 02:00:26')
Europe/Nicosia (354675599,'1981-03-29 03:59:59','1981-03-29 02:59:59')
Europe/Nicosia (354675600,'1981-03-29 04:00:00','1981-03-29 03:00:00')
Europe/Nicosia (354675601,'1981-03-29 04:00:01','1981-03-29 03:00:01')
Europe/Nicosia (386125199,'1982-03-28 03:59:59','1982-03-28 02:59:59')
Europe/Nicosia (386125200,'1982-03-28 04:00:00','1982-03-28 03:00:00')
Europe/Nicosia (386125201,'1982-03-28 04:00:01','1982-03-28 03:00:01')
Europe/Nicosia (417574810,'1983-03-27 04:00:10','1983-03-27 03:00:10')
Europe/Nicosia (417574811,'1983-03-27 04:00:11','1983-03-27 03:00:11')
Europe/Nicosia (417574812,'1983-03-27 04:00:12','1983-03-27 03:00:12')
Europe/Nicosia (859683599,'1997-03-30 03:59:59','1997-03-30 02:59:59')
Europe/Nicosia (859683600,'1997-03-30 04:00:00','1997-03-30 03:00:00')
Europe/Nicosia (859683601,'1997-03-30 04:00:01','1997-03-30 03:00:01')
Pacific/Efate (496803599,'1985-09-29 12:59:59','1985-09-29 11:59:59')
Pacific/Efate (496803600,'1985-09-29 13:00:00','1985-09-29 12:00:00')
Pacific/Efate (496803601,'1985-09-29 13:00:01','1985-09-29 12:00:01')
Pacific/Efate (528253199,'1986-09-28 12:59:59','1986-09-28 11:59:59')
Pacific/Efate (528253200,'1986-09-28 13:00:00','1986-09-28 12:00:00')
Pacific/Efate (528253201,'1986-09-28 13:00:01','1986-09-28 12:00:01')
Raw
test.sh
python - <<EOF > datatimetest.sql
import pytz
from datetime import datetime
ts_to_check = [9961200,73476000,325666800,354675600,370400400,386125200,388566010,401850000,417574811,496803600,528253200,624423614,636516015,671011200,717555600,752047218,859683600,922582800,1018173600,1035705600,1143334800,1162105223,1174784400,1194156000,1206838823,1224982823,1236495624,1319936400,1319936424,1425798025,1459040400,1509872400,2090451627,2140668000]
for tz in pytz.all_timezones:
timezone = pytz.timezone(tz)
print "select '{}', arrayJoin(arrayFilter(x -> x.2 <> x.3, arrayMap(x -> tuple(x.1, x.2, toString(toDateTime(x.1,'{}'))), [".format(tz,tz)
need_comma = 0
for ts2 in ts_to_check:
for ts in [ts2-1, ts2, ts2+1]:
print "{}tuple({},'{}')".format(',' if need_comma else '', ts, datetime.fromtimestamp(ts, timezone).strftime('%Y-%m-%d %H:%M:%S'), tz )
need_comma=1
print '] ) ) );'
EOF
cat datatimetest.sql | clickhouse-client -mn > datatimetest.reference
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment