The time data type
Mark Needham
ClickHouse 25.6 introduced the Time data type for storing time values. This video covers how to use the new Time and Time64 data types in your ClickHouse queries and tables.
What we'll cover:
- Creating Time values with casting and toTime() function
- Using Time64 for millisecond/nanosecond precision
- Required settings: enable_time_time64_type
- Practical example with running splits data
- Aggregating Time data (max, min, and workarounds for average/quantiles)
- Converting between Time types and Unix timestamps
We'll work through a real example using running data with moving time and elapsed time columns, showing how Time types make the data more readable compared to storing raw seconds.
Open House
Scaling ClickHouse to petabytes of logs at OpenAI
Open House
How ClickHouse helps Anthropic scale observability
Open House, User stories
How Capital One Slingshot cut infrastructure costs by 50%
Engineering leaders at Capital One Slingshot share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
Follow us
