Re: Date - Time in Fractions of a Second

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 11 Jan 2000 21:05:11 +0800
Message-ID: <387B2A87.168C@yahoo.com>

Uwe Schneider wrote:
>
> 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

You can get hundreth's of a second (sort of) by using dbms_utility.get_time.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Jan 11 2000 - 07:05:11 CST