v.1.1.54337New Feature

Improved Time Zone Support for DateTime Data Type

Official CH changelog text
Improved support for time zones. The DateTime data type can be annotated with the timezone that is used for parsing and formatting in text formats. Example: DateTime('Asia/Istanbul'). When timezones are specified in functions for DateTime arguments, the return type will track the timezone, and the value will be displayed as expected.
Improved support for time zones in the DateTime data type, allowing it to be annotated with a timezone for correct parsing and formatting in text formats.

Why it matters

This feature was created to address issues with handling DateTime values across different time zones. It ensures that when a timezone is specified, the parsing, formatting, and function return types correctly track and display the time zone, improving accuracy and usability for users working with datetime data in multiple locales.

How to use it

To use this feature, specify the timezone when declaring a DateTime column or variable using syntax like DateTime('Asia/Istanbul'). Functions that take DateTime arguments with timezones will then correctly track and return values with the associated timezone displayed as expected.
PreviousNext