My Oracle Support Banner

OBIEE 11g: 12/31/9999 Turned Out 1/1/1970 in Exported EXCEL 2007 (Doc ID 2115047.1)

Last updated on MARCH 18, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Microsoft Windows x64 (64-bit) - Version: 2008 R2


- Platform: Microsoft Windows 64
- Product Version:

The issue has been identified on Windows 64 port and not on the linux 64 port.

Date "9999/12/31" can be seen as "9999/12/31" on Analytics, but when exported to Excel 2007, it turned out to be "1/1/1970".

Tried to export "CAST('9999/12/31' AS DATE )" to Excel 2007, the date turned out to "1/1/1970" or "12/31/1969".
When you export "9999/12/31" to CSV, the date "9999/12/31" is as is. 

Applied the patch#20912569 but the issue did not solve.




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.