Replies: 3 comments 2 replies
-
Hi @HwiLu - looks like your clickhouse-server may be configured for UTC timezone. You can adjust this in your config file: https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings#timezone Otherwise, maybe try:
|
Beta Was this translation helpful? Give feedback.
-
This has no sense. |
Beta Was this translation helpful? Give feedback.
-
setting is
But
And in case |
Beta Was this translation helpful? Give feedback.
-
I mean there is a table like
when I insert values,
now('UTC')
seams does not workmy local timezome is
Asia/Shanghai
.and I try to insert with
insert into test_timezone(id) SETTINGS timezone='UTC' values(1)
, but error happendedReceived exception from server (version 22.8.15): Code: 115. DB::Exception: Received from localhost:9000. DB::Exception: Unknown setting timezone. (UNKNOWN_SETTING)
.Is there any way to resolve it instead of modifying conf and restart ck server
Beta Was this translation helpful? Give feedback.
All reactions