Oracle Analytics Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› Oracle Analytics Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Function to convert Timestamp to different timezones

Planned
51
Views
3
Comments
vkm
vkm Rank 5 - Community Champion
in Oracle Analytics Idea Lab

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

Tagged:
10
Up
10 votes

Planned · Last Updated

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

Comments

  • Bangaly Traore-Oracle
    Bangaly Traore-Oracle Rank 2 - Community Beginner

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

  • Luis E. Rivas -Oracle
    Luis E. Rivas -Oracle Mod

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

  • Michal Zima
    Michal Zima Rank 7 - Analytics & AI Coach

    @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.