Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Milli seconds for TIMESTAMP column

Received Response
11
Views
2
Comments
Rajesh Dhanapal
Rajesh Dhanapal Rank 4 - Community Specialist

Hi All,

I am trying to get milli second from a timestamp column. Although in Oracle database I can see the value e.g. 01-JAN-1970 00:00:00:150000000, I am not able to show milli second format in OBIEE.

Has anyone had this issue before or is there any workaround? your inputs are highly appreciated.

Best regards,

Rajesh Dhanapal.

Answers