Page 1 of 1

Get Milliseconds in Date & time?

Posted: Mon May 09, 2022 3:46 am
by 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