List:General Discussion« Previous MessageNext Message »
From:mos Date:November 17 2006 10:10pm
Subject:Re: float numbers
View as plain text  
At 03:29 PM 11/17/2006, Ahmad Al-Twaijiry wrote:
>Ho everyone
>
>I have a column in a table defined as float
>
>mynumber float(20,2)
>
>if we say mynumber column in a row is 1000000 ,  when I run this SQL :
>
>UPDATE Table SET mynumber=mynumber-100.15
>
>the mynumber column will be 999900 not 999899.85
>
>what is the problem ?

Ho Ho Ho,

Float only uses 4 bytes and does not have much precision so you'll get 
rounding. Try DOUBLE instead.

Mike
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