Time zone conversion
I have one WEBI report, having Transactions in Currency Section.
Now I need to show the transaction time which is in 'UTC' timezone (dbtimezone) into the timezone of the Currency (ultimately region).
Like if the currency is Euro then I would like to display the transaction time in CET timezone.
I tried to use oracle's from_tz & at timezone function in the dfx but its not working as expected.
Any help will be appreciated.