Get Milliseconds in Date & time?
Posted: Mon May 09, 2022 3:46 am
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
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