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

Convert UTC to Local Time in Oracle BI Publisher

Received Response
37
Views
3
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments

Summary

Convert UTC to Local Time in Oracle BI Publisher

Content

We need to convert UTC time to local time (Sydney) in Oracle BI Publisher XML output in Oracle Cloud ERP.

Since we cannot use BI template to handle the timezone conversion, we need to put this into the SQL.

however, the FROM_TZ doesn't seem to do the conversion at all.

Any idea what I am doing wrong here?

Thanks a lot.

select invoice_id,

last_update_date,

FROM_TZ(last_update_date, DBTIMEZONE)  AT TIME ZONE 'Australia/Sydney' as local_time

from ap_invoices_all

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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