Fails to deserialize `DateTime('Fixed/UTC±HH:MM:SS')` results

[itssimon]

Describe the bug

clickhouse-connect fails to deserialize results of type DateTime('Fixed/UTC±HH:MM:SS'), even though ClickHouse itself executes the same query successfully.

Code example

import clickhouse_connect

client = clickhouse_connect.get_client(host="localhost", port=8123)

result = client.query(
    "SELECT toStartOfInterval(now(), toIntervalHour(1), 'Fixed/UTC+05:30:00') AS ts"
)
print(result.first_item)

InternalError: Unrecognized ClickHouse type base: DateTime name: DateTime('Fixed/UTC+05:30:00')

The exact same SQL works over plain HTTP, for example:

curl -s "http://localhost:8123/?user=...&password=..." \
  --data-binary "SELECT toStartOfInterval(now(), toIntervalHour(1), 'Fixed/UTC+05:30:00') AS ts FORMAT JSONEachRow"

which returns:

{"ts":"2026-04-01 17:00:00"}

Configuration

Environment

• clickhouse-connect version: 0.15.0
• Python version: 3.13.11
• Operating system: macOS

ClickHouse server

• ClickHouse Server version: 25.8.16

[joe-clickhouse]

Hi @itssimon. The root cause looks we're having trouble parsing Fixed/UTC+05:30:00. The fix would involve first recognizing the Fixed/ prefix, then parsing the offset component to build a datetime.timezone from the timedelta(hours, mins, secs). It's probably worth checking server docs/source as well to see what the official format of the fixed offset is.