Hi Ahmad,
On 11/18/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> 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
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
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 th
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
an
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
wha
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
