v.21.4New Features

Add timezoneOf function and standardize timezone-related aliases

Official CH changelog text
Add function timezoneOf that returns the timezone name of DateTime or DateTime64 data types. This does not close #9959. Fix inconsistencies in function names: add aliases timezone and timeZone as well as toTimezone and toTimeZone and timezoneOf and timeZoneOf. #22001 (alexey-milovidov).
Introduces the timezoneOf function that returns the timezone name of DateTime or DateTime64 data types and adds consistent aliases for timezone-related functions.

Why it matters

This feature addresses inconsistencies in timezone-related function names and provides an easy way to retrieve the timezone name from DateTime or DateTime64 values, enhancing clarity and usability for users working with timezone-aware data.

How to use it

Use the new timezoneOf function by passing a DateTime or DateTime64 value to it to get its timezone name. Additionally, you can use any of the aliases timezone, timeZone, toTimezone, toTimeZone, timezoneOf, and timeZoneOf interchangeably in your queries for consistency.

Related resources

PreviousNext