Re: Granularity of ORACLE's date/time

From: <James>
Date: 1995/05/24
Message-ID: <1995May24.122353.8811_at_newton.ccs.tuns.ca>#1/1


In article <3otb0p$k3j_at_nova.sti.nasa.gov> khuguley_at_sti.nasa.gov (Karen Huguley) writes:
>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

Karen:

Database programs are used to store data rather than log data. Oracle probably never thought of it's Date datatype to allow for accuracy of ms. My guess is that you are using Oracle to analyze data. I would suggest to add a field for ms.

Hope this helps.

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!" Received on Wed May 24 1995 - 00:00:00 CEST

Original text of this message