Re: Date type in oracle

From: Martin Haltmayer <Martin_Haltmayer_at_in.augsburg.net>
Date: Sun, 05 Sep 1999 14:53:51 +0200
Message-ID: <37D267DF.EA0B98D6@in.augsburg.net>

There is a public synonym v$timer which will give you hundredths of seconds (but I don't know from when, I assume from startup).

For being able to query from that synonym you must have select permission on sys.v_$timer.

Information checked on Oracle8i.

Martin

lily99_at_my-deja.com wrote:
>
> My question with date in Oracle:
> I only know Oracle can store date up to a second, how I
> can handle a record with milliseconds. Any help will be
> appreciated.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Sep 05 1999 - 07:53:51 CDT