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: Does DATE datatype support milli-second

Re: Does DATE datatype support milli-second

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 18 Mar 1999 21:59:03 GMT
Message-ID: <36f1611e.406990@news.siol.net>


On Thu, 18 Mar 1999 16:07:13 +0800, Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:

>dbms_utility.get_time

Or even simplier, available from the view V$TIMER:

SELECT * FROM v$timer;

>and its hundredths not milliseconds..
>
>Cheers
>--
>==============================================
>Connor McDonald
>BHP Information Technology
>Perth, Western Australia
>"Never wrestle a pig - you both get dirty and the pig likes it..."

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Mar 18 1999 - 15:59:03 CST

Original text of this message

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