Hi,
Can anyone tell me how to store a 3 digit fraction of a second in a date column.
thanks
Printable View
Hi,
Can anyone tell me how to store a 3 digit fraction of a second in a date column.
thanks
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.