v.23.6New Feature

Add session_timezone setting for default timezone in sessions

Official CH changelog text
Add setting session_timezone; it is used as the default timezone for a session when not explicitly specified. #44149 (Andrey Zvonov).
Introduces the session_timezone setting, which specifies the default timezone for a ClickHouse session when no explicit timezone is provided.

Why it matters

This feature allows users to define a consistent default timezone for their sessions, ensuring query results and time-related functions behave predictably without needing to specify the timezone repeatedly in each query.

How to use it

Set the session_timezone setting at the beginning of the session or in the user profile configuration. This timezone will be used by default for any queries executed within that session unless explicitly overridden.

Related resources

PreviousNext