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

Loading and Retrieve Dates in Correct Format

Accepted answer
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments


Loading Dates formatted as mm/dd/yyyy type but they retrieve in scientific notation


The outline has the date type enabled.

The date fields that are loaded are tagged as date types.

Information loads correctly and I have confirmed the load file (.csv) has the dates formatted as mm/dd/yyyy.

When I go to retrieve (using the Dodeca Add-In), the dates retrieve in scientific notation (1.XXE+09) instead of mm/dd/yyyy.

Has anyone else encountered this problem and know a fix?

Howdy, Stranger!

Log In

To view full details, sign in.


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