Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Differences between Oracle RDBMS and MS SQL Server

Re: Differences between Oracle RDBMS and MS SQL Server

From: CSC <jcheong_at_cooper.com.hk>
Date: 7 Dec 2000 18:50:14 GMT
Message-ID: <90om56$97h3@imsp212.netvigator.com>

In comp.databases.ms-sqlserver Jesper Wolf Jespersen <jwj_at_dde.dk> wrote:
>

>> > - Oracle's handling of date/time strings is much less flexible than >> > SQL server  

>> Yes, SQLServer can generate 100's of a second time slices, however I
>> have yet to work on an application involving Oracle where that was a
>> show-stopper.  And, with 8 and 8i, EXTPROC provides the ability to call
>> external Java and C/C++ library routines to calculate time to that
>> granularity.

>
> Try dbms_utility.get_time which returns milliseconds resolution. Great for
> performance measurements.
>

Great! Is there new data type to store milliseconds with date?
-- 
e-Consultant
http://www.asl.com.hk/employment.htm
http://www.eroom.com
Received on Thu Dec 07 2000 - 12:50:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US