v.20.3Improvement

HTTP Responses to Include X-ClickHouse-Timezone Header

Official CH changelog text
From now on, HTTP responses will have X-ClickHouse-Timezone header set to the same timezone value that SELECT timezone() would report. #9493 (Denis Glazachev)
The HTTP response from ClickHouse now includes the X-ClickHouse-Timezone header indicating the current timezone used by the server.

Why it matters

This feature provides clients with explicit information about the server's timezone setting, matching the value returned by the SQL function SELECT timezone(). It helps users and applications understand how datetime values are handled and interpreted, improving transparency and easing troubleshooting related to timezone configurations.

How to use it

When making HTTP requests to ClickHouse, check the X-ClickHouse-Timezone header in the HTTP response to see the current timezone setting used by the server, which corresponds to the output of SELECT timezone().

Related resources

PreviousNext