Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI Report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI Report

in Reporting and Analytics for ERP 1 comment

I am using below code in data model to convert UTC to MT in report output. But column looses formatting when exported in excel and used in Pivots. How to achieve the same in .xpt format using format mask feature.

to_char(FROM_TZ(cast(converted_createddate as timestamp), 'GMT') AT TIME ZONE 'America/Denver', 'DD-Mon-YYYY HH:MI:SS PM','nls_date_language=english') as createddate

UTC data - 2025-03-20T17:35:26.897+00:00

Expected data - 20-Mar-2025 11:35:26 AM

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!