v.23.2New Feature

Add JodaTime format support for x, w, S

Official CH changelog text
Add JodaTime format support for 'x','w','S'. Refer to https://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html. #46073 (zk_kiger).
Added support for JodaTime date/time format specifiers 'x', 'w', and 'S' in ClickHouse formatting functions.

Why it matters

This feature enables users to utilize additional JodaTime format tokens when formatting dates and times, increasing compatibility and flexibility with JodaTime standards and allowing more precise and varied date/time output formatting.

How to use it

Users can include the new format specifiers 'x', 'w', and 'S' within their JodaTime-style format strings in relevant ClickHouse date/time formatting functions such as formatDateTime.

Related resources

PreviousNext