Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP:tenth of a second in a DATE format

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

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 11 Feb 2000 14:59:21 GMT
Message-ID: <881849$bpr$1@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 Fri Feb 11 2000 - 08:59:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US