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.
Can you please try to make the data-type of your column to TIMESTAMP in RPD and try?
I have already tried that option and it did not help.