# Querying DateTimes in ClickHouse

DevFeed: [Querying DateTimes in ClickHouse](<https://devfeed.tech/articles/querying-datetimes-in-clickhouse-5539.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/querying-datetimes>)

Author: Mark Needham

Published: 2026-03-20T00:00:00Z

Content type: tutorial

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [data](<https://devfeed.tech/topics/data.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [ascii](<https://devfeed.tech/tags/ascii.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [speed](<https://devfeed.tech/tags/speed.md>)

## AI overview

A practical guide to querying date and datetime columns in ClickHouse using the New York City taxi dataset. It covers hourly and 15-minute bucketing, filtering by date and time of day, calculating journey durations and average speed, and visualizing relative values with an ASCII bar chart.

## Source excerpt

How to query datetime columns in ClickHouse - from hourly bucketing to rush hour analysis with real taxi data.