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
Get Milliseconds in Date & time?
Get Milliseconds in Date & time?
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 25 guests