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

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Mon, 21 Feb 2000 18:27:03 +0100
Message-ID: <88rsmd$l39$1@news.inet.tele.dk>

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
Received on Mon Feb 21 2000 - 11:27:03 CST