How to convert a datetime columns from a timezone to another one — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How to convert a datetime columns from a timezone to another one

edited Dec 14, 2020 1:37PM in Reporting and Analytics for HCM 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!