Re: Granularity of ORACLE's date/time

In article <3otb0p$k3j_at_nova.sti.nasa.gov>, khuguley_at_sti.nasa.gov (Karen Huguley) writes:
::From: khuguley_at_sti.nasa.gov (Karen Huguley)
::Newsgroups: comp.databases.oracle
::Subject: Granularity of ORACLE's date/time
::
::I apologize for the simplicity of this question, but I am
::surprised at what I am finding with ORACLE's sysdate function.
::
::Is it possible to extract milliseconds from the system date/time?
::Seconds are not always granular-enough. Any suggestions?
::
::Thanks in advance,
::K. Huguley
::NASA Center for AeroSpace Information
::

 Not to my knowledge. Oracle DATE columns only hold times to seconds  and since SYSDATE is a pseudo DATE column it would appear to be the  same problem. Pity really since I have had occasions where a finer  timestamp would have saved me a lot of work.

 Perhaps some kind ORACLE employee who knows the reason may enlighten  us on this (something about the internal storage of date fields in  the 7 byte format perhaps ?) but it could well be lost in the mists of  time since this was a fundamental decision way back.

-- 
+--------------------------+-------------------------+-----------------------+
| Ian Bainbridge           | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS          | Newcastle Upon Tyne, UK |            x2790      |
+--------------------------+-------------------------+-----------------------+