To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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