Convert UTC to Local Time in Oracle BI Publisher
SummaryConvert UTC to Local Time in Oracle BI Publisher
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.
FROM_TZ(last_update_date, DBTIMEZONE) AT TIME ZONE 'Australia/Sydney' as local_time