Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method
Summary
Time data changes after exporting to Excel from BI publisher report - not used rtf templateContent
Hello everyone,
i have date data format in the database as 07-OCT-19 12.22.29.994000000 PM. (oracle database).
created datamodel and report based on above date field. properties set like
formating mask: MM/dd/yyyy hh:mm:ss tt
formatting style: Microsoft
ignore user timezone: True.
once i set above properties, in the report editor the date value displaying correctly as 10/07/2019 12:22:29 PM
Whereas once i generate the report and view in the excel output its displaying time as 10/07/2019 06:22:29 PM
why this time is changing? how to avoid this issue? please help me on this really appreciate it.