Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Floating point precision
Number(3) should do it. For display formats you should look at to_char in
the docs and the formats for that.
Jim
"D. Alvarado" <laredotornado_at_zipmail.com> wrote in message
news:9fe1f2ad.0205201400.5c39c3a9_at_posting.google.com...
> Hello,
> I have a question about floating point precision. Basically when I
> get floating point numbers from a table, I only want to see precision
> up to the third number after the decimal (the thousandth position).
> So my question is: is it possible to create a table with a floating
> point datatype with no more than 3 post-deciaml digits worth of
> accuracy (I discovered FLOAT(3) doesn't work)? Barring this, is there
> a way to display my floating point numbers so that I only get 3
> post-decimal digits worth of accuracy?
>
> Thanks in advance, Dave A.
Received on Mon May 20 2002 - 20:05:44 CDT
![]() |
![]() |