v.23.1New Feature

Allow DateTime Formatting in Joda-Time Style

Official CH changelog text
Allow formatting DateTime in Joda-Time style. Refer to the Joda-Time docs. #43818 (李扬).
ClickHouse now supports formatting DateTime values using the Joda-Time style patterns.

Why it matters

This feature enables users to format DateTime columns with familiar and flexible Joda-Time style patterns, improving date-time presentation and customization within queries.

How to use it

Use Joda-Time style format strings in functions that format DateTime values. Refer to the Joda-Time documentation for supported pattern syntax to customize output formats.

Related resources

PreviousNext