Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fractions (of a second) in dates
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