My Oracle Support Banner

OBIEE 11.1.1.9.1 Exporting To Excel Time Format Changing (Doc ID 2211434.1)

Last updated on APRIL 20, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.160419 and later
Information in this document applies to any platform.

Symptoms

OBIEE 11.1.1.9.x exporting to excel time format changing

Report has an analysis with a "TIME" variable in the RPD and time(0) in the underlying database (SQL). When building the analysis the time looks good, when exporting to PDF the value is maintained, however when exporting to excel (Excel 2007+ is the only option) all of the values are changed to 12/31/1969 4:59:59 PM


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.