List:General Discussion« Previous MessageNext Message »
From:Ahmad Al-Twaijiry Date:November 20 2006 6:00am
Subject:Re: float numbers
View as plain text  
Thanks all

I already switched all my FLOAT columns to DECIMAL and everything is
working fine :)

Thanks Again.

On 11/20/06, Asif Lodhi <itmailster@stripped> wrote:
> Hi Ahmad,
>
> On 11/18/06, Ahmad Al-Twaijiry <ahmadt@stripped> wrote:
> > I have many tables that use float (in production database), if I
> > convert all of the float column to DOUBLE or DECIMAL (using alter ),
> > is there any impact or anything I should know that could happen to me
> > ?
>
> You'll get a slight slow-down in performance - a trade-off you will
> make if you choose DECIMAL instead of FLOAT.  Even if you choose
> DOUBLE, there is a risk of rounding errors.  Try converting/casting
> the integer '1234567890' to float/double and assign the resulting
> float to an integer variable - then see what difference it makes.
> With DECIMAL you get accurate monetary calculations but slightly
> slower speed.
>
> --
> Asif
>


-- 
echo "Hello World :)"
Thread
float numbersAhmad Al-Twaijiry17 Nov
  • Re: float numbersDan Nelson17 Nov
    • Re: float numbersChris W18 Nov
  • Re: float numbersmos17 Nov
    • Re: float numbersAhmad Al-Twaijiry17 Nov
      • Re: float numbersDan Nelson17 Nov
      • Re: float numbersAsif Lodhi19 Nov
        • Re: float numbersAhmad Al-Twaijiry20 Nov
      • RE: float numbersJerry Schwartz20 Nov
  • ANN: SQL Maestro 6.12 releasedSQL Maestro Group14 Dec