v.22.10Improvement

Allow Date32 Arguments for dateName Function

Allow to use Date32 arguments for dateName function. #42554 (Roman Vasin).
Allow the dateName function to accept Date32 type arguments in addition to Date.

Why it matters

This feature extends the compatibility of the dateName function, enabling it to work with the Date32 data type. This improves flexibility and allows users to extract date parts from Date32 columns without type conversion, simplifying queries and improving usability.

How to use it

Simply pass a Date32 typed column or value as an argument to the dateName function just like with Date types. For example:

SELECT dateName('month', some_date32_column) FROM table;