system.time_zones

Contains a list of time zones that are supported by the ClickHouse server. This list of timezones might vary depending on the version of ClickHouse.

Columns:

  • time_zone (String) — List of supported time zones.

Example

  1. SELECT * FROM system.time_zones LIMIT 10
  1. ┌─time_zone──────────┐
  2. Africa/Abidjan
  3. Africa/Accra
  4. Africa/Addis_Ababa
  5. Africa/Algiers
  6. Africa/Asmara
  7. Africa/Asmera
  8. Africa/Bamako
  9. Africa/Bangui
  10. Africa/Banjul
  11. Africa/Bissau
  12. └────────────────────┘