milliseconds of a datetime function

[akwete]

1* SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS') "DateTime" FROM dual
2 /
DateTime
-------------------
11/21/2003 09:41:43. This date function gives up to the seconds. Is there any function or custom written one to get milliseconds of a time? For example, I want to see 11/21/2003 09:41:43:13.
Your input is highly appreciated.


K. C.
BI Consultant

[DaPi]

In 9i, yes. But not before. For example:
http://download-west.oracle.com/docs...31a.htm#999228
http://download-west.oracle.com/docs...30a.htm#999454

[akwete]

DaPi,

Thanks a lot. I am currently running on Oracle8i.


K. C.
BI Consultant