Subject | Re: [firebird-support] NUMERIC(18,6) calculation problem |
---|---|
Author | Luis Madaleno |
Post date | 2006-02-24T18:31:11Z |
Daniel Rail wrote:
loose? (using
DOUBLE PRECISION)
Will it at least be accurate at 6 decimal places?
Since this is for currency values if I get an accuracy of 6 decimal places at least, its fine for me.
Luis
> One way would be to create a UDF to make those calculations. TheCan you please tell me what would be the accuracy in the decimals I can
> other would be to cast your values as DOUBLE PRECISION values before
> the multiplication, but you might loose some accuracy in the decimals,
>
>
loose? (using
DOUBLE PRECISION)
Will it at least be accurate at 6 decimal places?
Since this is for currency values if I get an accuracy of 6 decimal places at least, its fine for me.
Luis