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

Home -> Community -> Usenet -> c.d.o.server -> Re: Fractions (of a second) in dates

Re: Fractions (of a second) in dates

From: Yong Huang <yhuang_at_indigopool.com>
Date: 2000/09/20
Message-ID: <8qbbbb$nm0$1@news.sinet.slb.com>#1/1

You can get tens of miliseconds granularity by the function dbms_utility.get_time. Oracle doesn't suppport anything below.

Yong Huang
yhuang_at_indigopool.com

spencer <spencerp_at_swbell.net> wrote in message news:KVUx5.172$zv6.81868_at_nnrp1.sbc.net...
> columns defined as DATE are used to represent a point in time,
> with a resolution down to seconds. In order to represent a finer
> resolution (for example, milliseconds or any other fraction of a
> second, you will need to use another datatype.
>
> btw... i believe this information is provided the concepts manual.
>
> "Andy Kent" <andykent.bristol.DontSpamMe_at_virgin.net> wrote in message
 news:ZzSx5.12679$6T1.195007_at_news2-win.server.ntlworld.com...
> > How can I access fractions of a second in a date column in SQL?
> >
> > -Andy Kent-
> >
> >
> >
>
>
Received on Wed Sep 20 2000 - 00:00:00 CDT

Original text of this message

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