1 | initial version |
One way to obtain the millisecond information from a date in Oracle is to use the EXTRACT function with the 'MICROSECOND' option. For example:
SELECT EXTRACT(MICROSECOND FROM sysdate) FROM dual;
This query will return the number of microseconds since the beginning of the current day, which can be divided by 1000 to obtain the millisecond value.