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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Does Oracle support miliseconds?

Re: Does Oracle support miliseconds?

From: Tony <trumsey_at_coda-enterprises.freeserve.co.uk>
Date: Tue, 30 Mar 1999 22:50:54 +0100
Message-ID: <7drh37$8k3$1@news8.svr.pol.co.uk>


There is a package call DBMS_UTILITY which returns the time in hundredths of a second, however you have to store it in a seperate number column as the DATE datatype only supports times down to seconds.

example:-

SELECT SYS.DBMS_UTILITY.GET_TIME from DUAL ; Received on Tue Mar 30 1999 - 15:50:54 CST

Original text of this message

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