List:General Discussion« Previous MessageNext Message »
From:Ahmad Al-Twaijiry Date:November 17 2006 9:29pm
Subject:float numbers
View as plain text  
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 ?



-- 
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