Oracle Analytics Cloud and Server

Products Banner

Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method

Received Response
340
Views
6
Comments

Summary

Time data changes after exporting to Excel from BI publisher report - not used rtf template

Content

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.

P.S. i am not using rtf template method design. in 11g getting properly values wheras in 12c getting issue.

Regards,

Joe

Answers