4 ms·

Also fun reading: "Limitations on time zones support" at https://clickhouse.com/docs/en/sql-reference/data-types/datetime#limitations-on-time-zones-support http

Also fun reading: "Limitations on time zones support" at https://clickhouse.com/docs/en/sql-reference/data-types/datetime#limitations-on-time-zones-support https://clickhouse.com/docs/en/sql-reference/data-types/date... > A similar issue exists for Casey Antarctic station in the year 2010. They changed the time three hours back on 5 Mar, 02:00.

madcaptenor 3y ago
It looks like Casey is +11 in southern summer and +8 in southern winter - apparently they're supplied out of Tasmania, so they match Tasmanian time in the summer, but match the time of their longitude during the winter. Something similar happens at the Norwegian base Troll, which is +0 in southern summer (in accordance with its location) and +2 in southern winter (which is northern summer, so they match the time in Norway).