Subject | NUMERIC(18,6) PRECISION |
---|---|
Author | Luis Madaleno |
Post date | 2005-06-21T16:34:46Z |
Hi,
I have my currency fields defined to be a NUMERIC(18,6), but I have
precision problems.
If I enter this value: -654646 FB stores this: -654646,000000000116
Is there any way of avoiding this?
What is the best format for currency values?
I can't use this in my apps, because if I compare the user -654646 is <>
of the DB -654646,000000000116,
and this will cause many conflicts.
Regards,
Luis Madaleno
I have my currency fields defined to be a NUMERIC(18,6), but I have
precision problems.
If I enter this value: -654646 FB stores this: -654646,000000000116
Is there any way of avoiding this?
What is the best format for currency values?
I can't use this in my apps, because if I compare the user -654646 is <>
of the DB -654646,000000000116,
and this will cause many conflicts.
Regards,
Luis Madaleno