v.23.10Improvement

Functions Enhance Compatibility with String-Encoded Date Arguments

Official CH changelog text
Functions (add|subtract)(Year|Quarter|Month|Week|Day|Hour|Minute|Second|Millisecond|Microsecond|Nanosecond) now support string-encoded date arguments, e.g. SELECT addDays('2023-10-22', 1). This increases compatibility with MySQL and is needed by Tableau Online. #55869 (Robert Schulze).
Functions (add|subtract)(Year|Quarter|Month|Week|Day|Hour|Minute|Second|Millisecond|Microsecond|Nanosecond) now accept string-encoded date arguments, allowing usage like SELECT addDays('2023-10-22', 1).

Why it matters

This feature improves compatibility with MySQL by enabling date functions to parse date values provided as strings. It also addresses requirements from Tableau Online, making ClickHouse more flexible and easier to integrate with such tools.

How to use it

Simply pass date arguments as strings to these functions, for example: SELECT addDays('2023-10-22', 1). No additional configuration is needed.

Related resources

PreviousNext