v.22.11Improvement

Allow Date32 Arguments for formatDateTime and FROM_UNIXTIME Functions

Allow to use Date32 arguments for formatDateTime and FROM_UNIXTIME functions. #42737 (Roman Vasin).
Enable the use of Date32 type arguments in formatDateTime and FROM_UNIXTIME functions.

Why it matters

This feature extends the compatibility of date-time functions by allowing Date32 inputs, solving the limitation where these functions previously only accepted other date types. It enhances the flexibility and usability of date processing in ClickHouse queries.

How to use it

Users can now pass Date32 columns or values directly as arguments to the formatDateTime and FROM_UNIXTIME functions without needing to convert the data type.