How to write SQL query for milliseconds in Oracle.

For example In my table one datetime field example modified_date_time.
its displaying 2006-08-18 23:28:23 (here its rounding seconds)
But I want the format like 2006-08-18 23:28:22.123456 (I want the absolute value for seconds like yyyy-mm-dd HH24:mi:ss.milliseconds.

Showing Answers 1 - 1 of 1 Answers

Siva

Aug 23rd, 2007

You can use like the following

SELECT TO_CHAR(systimestamp,'yyyy-mm-dd HH24:mi:ss.FF') FROM DUAL;

which gives you like 2007-08-23 14:12:36.769726