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.
ClickHouse at DoorDash
How DoorDash monitors TCP and DNS traffic helping their observability team take care of their kubernetes infrastructure.
ClickHouse v25.10 Release Webinar
Alexey Milovidov
Moderniser l’observabilité avec ClickStack : simplifier, accélérer, innover
L’observabilité n’a jamais été aussi critique… ni aussi complexe. Êtes-vous prêt à transformer votre manière de gérer la complexité des systèmes distribués ? Découvrez comment ClickHouse révolutionne l’observabilité moderne en combinant rapidité, efficacité et ouverture.
