Oracle Analytics Cloud and Server

Products Banner

Convert UTC to Local Time in Oracle BI Publisher

Received Response
232
Views
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

Answers