Subject | Re: [firebird-support] Firebird 2.1 Dialect 3 Decimal Number Limits |
---|---|
Author | Ann W. Harrison |
Post date | 2009-04-01T22:32:50Z |
Ann W. Harrison wrote:
value = <stored value> * 10^(<scale factor> * -1>)
123.45 = 12345 * 10^-2
Ann
>left out the word 'times' in the description
> The 6 in decimal(6,2) is the precision. It includes the
> decimal digits. So the legal range is not -999,999.99 to
> +999,999.99 but -999,999 to +999,999 and the scale factor
> is added later by multiplying by 10 to the scale factor
> minus one.
value = <stored value> * 10^(<scale factor> * -1>)
123.45 = 12345 * 10^-2
Ann