Re: Help displaying time in 1/1000th seconds

From: Marc Billiet <Marc.Billiet_at_hae.hydro.com>
Date: Mon, 05 Oct 1998 07:29:08 +0100
Message-ID: <36186734.B26@hae.hydro.com>

Paul Reavis wrote:
>
> I think I have a kludge/fix in converting a date to a number (to_num) and
> then dividing out the days... to get the mod of seconds for a time and then
> present this distinct from the time to get the sub-second interval -- I
> think this will work but I have not tried it yet. But I suspect that there
> _has_ to be a more elegant way....
>
> All the to_char(...) formats seem to end at ss and I need something more
> precise.
>
> Thanks for any help you might offer.
>
> Paul Reavis
> preavis_at_hopkinscarley.com

DBMS_UTILITY.GET_TIME returns the time in 1/100th's of a second. This is still not 1/1000th, but already better than the difference between two dates.

Marc Received on Mon Oct 05 1998 - 01:29:08 CDT