Does anyone know how to convert dynamic timezone in Oracle SQL via Data Model?

Hazel De Castro

Summary:

Is there a way to dynamically convert timezone based on what timezone is being set in UI? (specifically in learning activity start time and end time)

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

MandeepGupta

Please check if below helps:

http://fusionhcmconsulting.com/2021/03/reports-bip-query-to-get-correct-time-zone/

Thanks.

Bhaskar Konar

Thank you very much Mandeep.

Appreciate your help.

Cheers,