Clickhouse changing column timezone by using a separate timezone column(string)

Backend Development
1

Example Clickhouse Schema

enter code here

DateTable

Date Timezone
May 19, 2023, 04:00:00 Europe/London
May 19, 2023, 04:00:00 Asia/Kolkata

I can change timezone using the function toTimezone(date, 'Europe/London').

But I can’t use toTimezone(date, timezone).

I want to run a query like this

select toTimezone(date, timezone) from DateTable

It says ClickHouse timezone conversion needs a const String. Any workaround over this would help a lot.

2

have you got solution for this