Function to convert Timestamp to different timezones

vkm

Description

Need a function in OAC to convert timestamp from one timezone to another, either in the prepare stage while creating the dataset or in visualization calculations.

Use Case and Business Need

convert usage tracking of OAC that is stored in UTC to the user timezone

Original Idea Number: f04949ee60

Bangaly Traore-Oracle

My organization requires this functionality in order to display results to users such that the times displays in their timezone

Luis E. Rivas -Oracle

This would definitely be a useful feature. It is now in the backlog. We will update when this makes progress.

Michal Zima

@Bangaly Traore-Oracle If you are "reporting" against Oracle Db (meaning your data sets are created against connections to Oracle DB or your metadata/semantic model are using Connection Pools to Oracle DB) you can in meantime use following "workaround" - you can use Oracle Db function to_timestamp_tz "wrapped" by BI Server function EVALUATE.