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: Date format

Re: Date format

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 20 Jan 2000 22:26:52 GMT
Message-ID: <38878994.14374215@news.demon.nl>


On Thu, 20 Jan 2000 21:29:53 GMT, narenn_at_my-deja.com wrote:

>Does oracle store date upto a milli second resolution. If so how to
>set the nls_date_format to get upto this resolution?
>
>Thanks
>
>-Naren
>Tech Application Specialist
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

No.
You could use dbms_utility.get_time to get similar info, however that counts from server boot.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jan 20 2000 - 16:26:52 CST

Original text of this message

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