Re: Date format

From: Daniel <delj_at_flash.net>
Date: Thu, 20 Jan 2000 23:11:36 GMT
Message-ID: <ICMh4.6862$V84.384436@news.flash.net>

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
Received on Thu Jan 20 2000 - 17:11:36 CST