Datasphere Timestamp UTC convert to local time

[vera_ju]

Hi,

our Datasphere is in UTC. We implemented a calculated column for loading time (timestamp). But the users should see it in local time (example Germany). And a special topic: summer and winter time!

At the moment I add the following expression: ADD_SECONDS(CURRENT_TIMESTAMP(),7200)

But we have more then 40 views and it must be done in each. In case of change from summer to winter time it must be change from 7200 to 3600.

So I'm searching for a possibility to create a customer expression or some other ways. In this case we must change the value (seconds) only on one position not on 40!

Regards,

Maren

[JanLang]

Have you tried UTCTOLOCAL Function?