How to convert a datetime columns from a timezone to another one
Content
Hi,
we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity from 9AM to 6PM CET (Europe/Berlin is the timezone selected in the application). From what we have seen in the backend, the activity start and end date are stored in the fields ACTIVITY_START_DATETIME and ACTIVITY_END_DATETIME of the view WLF_CI_ACTIVITY_DETAILS_V and the timezone is stored in the ACTIVITY_TIME_ZONE column of the same view.
The problem is that the dates are stored in UTC and we want them in the defined timezone (Europe/Berlin). How can we convert the datetime columns in the correct timezone