Re: FLOAT

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Wed, 2 Nov 2005 11:19:15 -0500, Rogers wrote:

>I want to use only float datatype but the problem is that it return more
>than two decimal, I want to minimize to two decimal points? I don't want to
>use decimal datatype.... I only wanna use float.....
>
>The result should looks like
>
>152254.45
>
>but now it's giving me.
>
>152254.45123232363
>
>Any solution ?

Hi Rogers,

No, of course not. The FLOAT datatype is designed to *not* have an exact
and limited number of decimals. The datatypes that are designed to offer
a fixed number of decimal places are decimal and numeric.

Saying "I want to have two decimal points but I don't want to use
decimal datatype... I olnly wanna use float" is like saying "I want to
travel by air but I don't want to use a plane... I only wanna use a
boat".

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Re: FLOAT
    ... I only want to use float datatype because I have to frequenly convert the ... > and limited number of decimals. ... I olnly wanna use float" is like saying "I want to ...
    (microsoft.public.sqlserver.clients)
  • Re: abundance of irrationals!)
    ... >> It seems to me that what he's saying is that the number 0, ... Consider the sequence of rational decimals in which a_n ...
    (sci.math)
  • Re: the seven first decimals of pi
    ... Mike Barnes wrote: ... how do I go about saying ... this (as the above is a bit clumsy)? ... "The first seven decimals of pi are 3,1415926", that's wrong as the ...
    (alt.usage.english)
  • Re: the seven first decimals of pi
    ... how do I go about saying ... this (as the above is a bit clumsy)? ... "The first seven decimals of pi are 3,1415926", that's wrong as the ... Or alternatively the value of pi to seven significant figures is the ...
    (alt.usage.english)