Re: Will "date" attribute support time less than seconds (ie. milliseconds) ?

Home -> Community -> Usenet -> c.d.o.misc -> Re: Will "date" attribute support time less than seconds (ie. milliseconds) ?

From: Kevin Reardon <kreardon_at_cerere.na.astro.it>
Date: 1997/04/08
Message-ID: <334A64B5.7CB4@cerere.na.astro.it>#1/1

Michael Ho wrote:
>
> A Ustby wrote:
> > Will "date" attribute support time less than seconds (ie. milliseconds) ?
>
> Unfortunitely No.

So, if there is no way to store a random time (I believe DBMS_UTILITY.GET_TIME only gets the current system time) in a DATE with millisecond accuracy, what tricks do people use to store times with accuracy better than one second? Everything down to the second in DATE column, and a separate NUMBER(3) column for the milliseconds? Stores the times in a single column as floating-point seconds past midnight, Julian Dates, or some such contrivance? What is the collective wisdom on this problem?

kevin reardon
Osservatorio Astronomico di Capodimonte Received on Tue Apr 08 1997 - 00:00:00 CDT