Milli seconds for TIMESTAMP column

Question

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.

Rajesh Dhanapal · Answer

I have already tried that option and it did not help.

SonPat99 · Answer

Hello Rajesh,

Can you please try to make the data-type of your column to TIMESTAMP in RPD and try?