Dan Nelson wrote:
Since base-10 fractions can't be represented exactly by a base-2
floating-point number, any fractional value you store will be
imprecisely stored and will cuase rounding errors.
That isn't exactly true. If you were to add the word always between
can't and be, it would
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 100 , when I run this SQL :
UPDATE Table SET mynumber=mynumber-100.15
the mynumber column will be 00 not 999899.85
what is the problem ?
--
echo Hello World :)
--
In the last episode (Nov 18), Ahmad Al-Twaijiry said:
I have a column in a table defined as float
mynumber float(20,2)
if we say mynumber column in a row is 100 , when I run this SQL :
UPDATE Table SET mynumber=mynumber-100.15
the mynumber column will be 00 not 999899.85
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 100 , when I run this SQL :
UPDATE Table SET mynumber=mynumber-100.15
the mynumber column will be 00 not 999899.85
Thanks Dan Mos
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
?
is there any page that describe the differences between FLOAT, DECIMAL
In the last episode (Nov 18), Ahmad Al-Twaijiry said:
Thanks Dan Mos
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?
is there any