Re: Date format

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 21 Jan 2000 18:18:15 +0800
Message-ID: <38883267.7F40@yahoo.com>

Daniel wrote:
>
> Do not rely on nls_date_format to perform your masking by default. Use the
> formating string in to_date and to_char to mask the date to the resolution
> you want.
>
> Daniel
> Austin, TX
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:38878994.14374215_at_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

No combination of date format will get anything less than 1 second.

You need to use v$timer or equivalent.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jan 21 2000 - 04:18:15 CST