Re: How to store fractional seconds

Sorry about that. I was expecting that since I didn't get a syntax error I got what I wanted. Now, is that a bug, or BAD?

"Scott Mattes" <smattes_at_erols.com> wrote in message news:8v3kls$o4p$1_at_bob.news.rcn.net...
> Shouldn't a regulare date field give you what you want (with rounding of
> course)?
>
> select to_char( sysdate, 'YYYY MM DD HH:MI:SSSSSSS' ) from dual;
>
> TO_CHAR(SYSDATE,'YYYYMMD
> ------------------------
> 2000 11 17 11:03:3978303
>
>
>
> <jlobugli_at_mwra.state.ma.us> wrote in message
> news:8v3j6s$kk4$1_at_nnrp1.deja.com...
> > I have to store a date/time down to the tenth of one second. I see my
> > options as:
> >
> > 1) Use two fields, a date field which goes down to the second and and a
> > number field storing the fraction of a second. The number field could
> > store either (a) an integer being the number of tenths of a second
> > (number(1,0)) or (b) the fraction of a second to some greater precision
> > (number(3,3)).
> >
> > 2) An Excel-like number representing the number of days since a fixed
> > time, stored to enough precision to capture at least 1/10 of a second.
> >
> > I am leaning towards option 1(a), though I am open to any other
> > suggestions. I am storing streamed instrument data so there will be
> > millions of rows stored.
> >
> > I am using Oracle7 Server Release 7.1.5.2.3. Would there be a better
> > solution with Oracle 8i? We will (hopefully) be upgrading soon.
> >
> > Thanks
> >
> > Joe LoBuglio
> > joe.lobuglio_at_mwra.state.ma.us
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Nov 17 2000 - 15:50:08 CST