You cannot get miliseconds from DATE type,
but you may try to use DBMS_UTILITY.GET_TIME function:
"This function finds out the current time in 100th's of a second. It is primarily useful for determining elapsed time. "
You have to add another column to the table to store value returned by DBMS_UTILITY.GET_TIME function.




Reply With Quote