-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|