Get Milliseconds in Date & time?

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Get Milliseconds in Date & time?

Post 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
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests