How to store Fraction of a Second

[msuresh]

Hi,
Can anyone tell me how to store a 3 digit fraction of a second in a date column.

thanks

[stecal]

SQL> SELECT CURRENT_TIMESTAMP(6) FROM DUAL;

CURRENT_TIMESTAMP(6)
---------------------------------------------------------------------------
15-JUL-02 03.39.15.959608 PM -06:00

current_timestamp(N) where N = # of digits for precision

Date datatype won't work for you. Need something like timestamp datatype which came out in 9i.