| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to store fractional seconds
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
<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 - 10:01:01 CST
 |
 |