Re: Fractional seconds in a DATE field?

Mark,

I looked up all the date formats and couldn't find anything more precise than seconds. I'm no expert, but if I needed more precision than seconds I would just use a VARCHAR2 and store all the precision I needed.

Paul Cluiss
Dallas, Texas

Mark Ohrenschall wrote:

> Are seconds the highest precision with which I can store DATEs in
> Oracle? I have data with timestamps that include hundredths of seconds;
> is there a way I can preserve factional seconds in a date field?
>
> Thanks,
>
> Mark Ohrenschall
> mao_at_ngdc.noaa.gov
Received on Thu Sep 16 1999 - 16:44:31 CDT