Get Milliseconds in Date & time?

[admin]

Hi,
The following query can be used to get milliseconds in the date & time stamp,

SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF') FROM DUAL;
SELECT to_char (SYSTIMESTAMP, 'DD-Mon-RR HH24:MI:SS.FF3') FROM DUAL;

08-May-22 23:38:13.698

Reference_R21