My Oracle Support Banner

Exporting Result Set To Excel With Dates From January 1970 - October 1971 Are Off 1 Day (Doc ID 2878291.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Oracle Analytics Server - Version 5.9.0 and later
Information in this document applies to any platform.

Symptoms

Viewing result set containing dates ranging January 1970 - October 1971 show correct on the screen.

When exporting to Excel, dates are 1 day off.

Exporting to CSV or other Unformatted export options does not have this issue. Other Formatted options also do not replicate this issue, only Excel.

It happens for all browsers.

 


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!


In this Document
Symptoms
Changes
Cause
Solution


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