v.23.6Improvement

Functions toDateOrDefault and accuateCast now parse numeric arguments correctly

Official CH changelog text
Functions "toDateOrDefault|OrNull" and "accuateCast[OrDefault|OrNull]" now correctly parse numeric arguments. #50709 (Dmitry Kardymon).
The functions toDateOrDefault, toDateOrNull, accurateCast, accurateCastOrDefault, and accurateCastOrNull now correctly parse numeric arguments.

Why it matters

This feature resolves parsing issues with numeric arguments in these conversion functions, ensuring they behave as expected and improve data type conversion reliability in queries.

How to use it

Use the functions toDateOrDefault, toDateOrNull, accurateCast, accurateCastOrDefault, and accurateCastOrNull as usual in your ClickHouse queries. They now handle numeric arguments correctly without additional configuration.

Related resources

PreviousNext