Re: Date format

From: Karen Abgarian <abvk_at_ureach.com>
Date: Thu, 15 Aug 2002 07:08:18 GMT
Message-ID: <3D5A01C2.AECDA464@ureach.com>

it could show even 10 if you set the format mask accordingly.

dates are stored up to seconds.

the only thing in oracle that provides somehow for better resolution is V$TIMER, it gives you centiseconds.

you probably do not need anything but seconds for any practical purposes.

after all, Oracle is not a real-time system.

Hth
AK

Hugues Parvillers wrote:

> .FF
>
> but it shows 6 digits !
>
> Jayme Assuncao Casimiro a ?crit :
>
> > I would like to know how to characterize the miliseconds format in this
> > date format:
> >
> > DATE
> > '2001-08-30 00:00:00.0',
> >
> > FORMAT
> > 'YYYY-MM-DD HH24:MI:SS.?'
> >
> > wHAT DO i PUT in ? to complete the correct format?
> >
> > Thanks
> >
> > --- Jayme
Received on Thu Aug 15 2002 - 02:08:18 CDT