Converting UTC Timestamp in AWS Athena to Timestmap in time zone europe/berlin

[Xclipse]

Hi @Markus

To convert your date from UTC to Europe/Berlin local time, please try using the following calculated field.

Example:

rwk_date_local - parseDate(formatDate({rwk_date},"yyyy-MM-dd HH:mm:ss",'Europe/Berlin'), "yyyy-MM-dd HH:mm:ss")

Please refer to the below community post this might be helpful for you.

Convert ISO8601 Timestamps to Europe/Berlin Time (Timestream)

Hi everyone, I’m using an AWS Timestream dataset in QuickSight, which contains ISO8601 timestamps. According to this documentation, custom time zones are not supported for Timestream. I need to convert these timestamps to the Europe/Berlin time zone and use them in my analysis. How can I achieve this within QuickSight? I have already tried to insert a calculated field (time-eu-berlin). But it is converted back to UTC in my analysis? parseDate(formatDate({time},"yyyy-MM-dd HH:mm:ss",'Europe/B…