Datetime

ClickHouse Puts the Time Zone in the Type, Not the Value

Oct 24, 2026 23 min read Jay Hubbert

ClickHouse’s DateTime is Unix seconds plus a time zone that lives in the type, backed by a 146097-day lookup table per zone.

ClickhouseInternalsDatetimeTimezoneTypes

Read more →