Re: TO_DATE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/30
Message-ID: <954419175.636.0.pluto.d4ee154e@news.demon.nl>#1/1

Maxim A Sokolnikov <max_at_mpsb.moris.ru> wrote in message news:38E33B63.C35AB712_at_mpsb.moris.ru...
>
>
> Sybrand Bakker wrote:
>
> > Oracle doesn't capture fractions of a second, so the answer is no, you
can't
> > do that.
>
> Not exactly.....
> For Oracle 8 use dbms_utility package
> function get_time return number;
> -- Find out the current time in 100th's of a second.
> -- Output arguments:
> -- get_time
> -- The time is the number of 100th's of a second from some
> -- arbitrary epoch.
>
>
>
> >
> > Sorry,
> > Sybrand Bakker, Oracle DBA
>
> For Oracle 8 use dbms_utility package
> function get_time return number;
> -- Find out the current time in 100th's of a second.
> -- Output arguments:
> -- get_time
> -- The time is the number of 100th's of a second from some
> -- arbitrary epoch.
>
>
> Maxim Sokolnikov Oracle DBA
>
>

I'm well aware of that, but AFAIK the timer is reset the database is bounced.
Hence useless for realtime purposes.

Sybrand Bakker, Oracle DBA Received on Thu Mar 30 2000 - 00:00:00 CST