Re: Differences between Oracle RDBMS and MS SQL Server

From: Jesper Wolf Jespersen <jwj_at_dde.dk>
Date: Thu, 7 Dec 2000 20:56:02 +0100
Message-ID: <%XRX5.247$bK3.7128@news.get2net.dk>

"CSC" <jcheong_at_cooper.com.hk> wrote in message news:90om56$97h3_at_imsp212.netvigator.com...
> > Try dbms_utility.get_time which returns milliseconds resolution. Great
for
> > performance measurements.
> >
> Great! Is there new data type to store milliseconds with date?

Not that I know off. The time returned by dbms_utility.get_time is returned in a number, and there is no specification of the reference. You do not know when this time has its origin, so you can only use it for diferential measurements.

Many operating systems have something simmilar, it helps you time things without revolutionizing the storage of time parameters :-)

Seasons greetings from Denmark

Jesper Wolf Jespersen Received on Thu Dec 07 2000 - 13:56:02 CST