Re: HELP:tenth of a second in a DATE format

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Wed, 23 Feb 2000 16:05:01 -0800
Message-ID: <38B475AD.B4A1DFDA@vnl.nl>

Finn Ellebaek Nielsen wrote:

> Subseconds aren't supported in Oracle, hopefully it will be there with
> 8.2...
>
> HTH.
>
> Finn
>
> Ms. D.H. Harvey <qq45_at_liverpool.ac.uk> wrote in message
> news:881849$bpr$1_at_news.liv.ac.uk...
> > Pierre Charpenay (pcharpenay_at_unilog.fr) wrote:
> >
> >
> > : Alexander Podgorny wrote :
> >
> > : > Hi ALL!
> > : > Could anybody tell me which character
> > : > is responsible for tenth of a second in a DATE format string
> > : > such as
> > : >
> > : > 'DD-MM-YYYY HH:MI:SS<and what must be here for fractions of a
> second???
> > : > > '
> >
> > : 'DD-MM-YYYY HH:MI:SS:CC'
> > : ==
> >
> > : But, as far I know, it's always 00.
> >
> > This is because CC is century !!!
> >
> > HTH Helen
> >
> > : Can anybody else confirm.
> >
> > : >
> > : > Thanks.
> > : >
> >
> > : --
> > : Pierre CHARPENAY

Take a look at the dbms_utility.get_time function, it's been there a while!
Not in SQL, indeed, but supported, yes

Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle Received on Wed Feb 23 2000 - 18:05:01 CST