Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Issue with Datetime @ BI Publisher
an_dario
Rank 2 - Community Beginner
Summary
Issue with Datetime @ BI Publisher
Content
Hi everyone!
I'm building a DM based on an SQL query which extracts an timestamp value. When I got data from it, the value is shown in UTC format. I need to be shown in my local timezone (America/Bogota -05:00).
You'll say "Well! Use the FROM_TZ function!"... The thing is, when I do, the timestamp increases its value instead of decrase which is what should happened! I don't know what I need to do to fix this.
The value in UTC is 2018-02-20T04:19:40. After pass it through FROM_TZ function the shown value is 2018-02-20T09:19:40
Thanks!
0