Tinybird Code
The CLI AI ClickHouse® expert for your projects
tinybird.ai
The analytics backend for your app and agents
Hosted OLAP Database
The world's fastest analytics database without the hassle
APIs
Every query is a scalable and secure REST API
Events API
Stream JSON at 1k+ RPS with an HTTP request
Tinybird Local
Run Tinybird on your machine or your own infra
CLI
Create, build, test, and deploy from your terminal
Observability
The Simple, High‑Performance Observability Stack
Integrations
Connect to dozens of dev tools and data sources
Back to columns
ClickHouse Examples
Sep 18, 2025
How to compute the difference between two timestamps in specific units using age() in ClickHouse®
Learn how to use ClickHouse's age() function to calculate complete time units between timestamps, from nanoseconds to years, with syntax examples and practical queries.
1How to compute the difference between two timestamps in specific units using age() in ClickHouse®
Sep 18, 2025
How to convert values to DateTime64(6) using timestamp() in ClickHouse®
Learn how to convert strings, timestamps, and date values to DateTime64(6) using ClickHouse's timestamp() function with microsecond precision and optional time addition.
1How to convert values to DateTime64(6) using timestamp() in ClickHouse®Sep 18, 2025
How to create a date from year, month, and day components in ClickHouse®
1How to create a date from year, month, and day components in ClickHouse®Sep 18, 2025
How to retrieve current session timezone using timeZone() in ClickHouse®
1How to retrieve current session timezone using timeZone() in ClickHouse®Sep 18, 2025
How to calculate date differences using unit boundaries with dateDiff in ClickHouse®
1How to calculate date differences using unit boundaries with dateDiff in ClickHouse®Subscribe to SCHEMA > Evolution
We are Tinybird and we manage data for companies like Vercel and Canva. Plus, write a newsletter covering Data, AI and everything that matters in between. Join us.
Skip the infra work. Deploy your first ClickHouse
project now.
Copyright © 2025 Tinybird. All rights reserved
|
