Re: Fractions (of a second) in dates

the last project i worked on stored medical information and required absolute time storage with millisecond precision. the information was gathered by java middleware and stored in number(16,0) columns as milliseconds since the epoch (1970-JAN-1).

the java middleware handled all of the translations as appropriate. in addition, we added a few trivial pl/sql functions to the database that allow for standard sql access with 1 second granularity.

hth,
tim hentzel

http://www.codegarden.com

In article <8qbbbb$nm0$1_at_news.sinet.slb.com>,   "Yong Huang" <yhuang_at_indigopool.com> wrote:
> 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-
> > >
> > >
> > >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 21 2000 - 00:00:00 CDT