Re: Date - Time in Fractions of a Second

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Tue, 11 Jan 2000 16:50:11 +0100
Message-ID: <387B5133.83425D4D@xlink.net>

Hi Bret,

Bret wrote:
>
> Platform: Oracle 8.0.5 on Sun Solaris. Application written in Java
> using JDBC.
> Is there any way to get the date-time in fractions of a second? Can
> this also be retrieved using the TO_CHAR function? I need a time stamp
> in milliseconds and cannot read the date any more granular than
> seconds. Thanks

the finest granulation of a native Oracle timestamp is second. To provide for fractions of seconds you have to enhance date/time storage and operations yourselv, e.g. by an additional column time_millies and a special package.

I am not aware of any public available code for this.

Uwe

--
uwe.schneider_at_xlink.net Received on Tue Jan 11 2000 - 09:50:11 CST