My Oracle Support Banner

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

Last updated on APRIL 01, 2019

Applies to:

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


OBIEE 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


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

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

In this Document

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