v.21.7New Feature
Added dateName function for day and month names by Daniil Kondratyev
Added function dateName to return names like 'Friday' or 'April'. Author [Daniil Kondratyev] (@dankondr). #25372 (Maksim Kita).Why it matters
This feature provides users with a simple way to retrieve human-readable names for date parts directly from their date or datetime columns, improving readability and convenience in date-related queries.How to use it
Use thedateName function in your queries by passing the desired date part and the date or datetime value. For example:SELECT dateName('weekday', some_date_column) FROM table;
SELECT dateName('month', some_date_column) FROM table;