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

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Wed, 23 Feb 2000 22:48:14 +0100
Message-ID: <891kob$p1g$1@news.inet.tele.dk>

We're talking about the DATE data type here. You cannot use DBMS_UTILITY.GET_TIME for much, apart from timing... On Windows NT for instance, it rolls over every 50 days.

What we really need is a DATE (date part only), TIME (time part only, down to 1/1000s) and a DATETIME (date and time, down to 1/1000s).

Finn

Frank van Bortel <f.van.bortel_at_vnl.nl> wrote in message news:38B475AD.B4A1DFDA_at_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 - 15:48:14 CST