Subject Re: [firebird-support] Firebird 2.1 Dialect 3 Decimal Number Limits
Author Ann W. Harrison
Ann W. Harrison wrote:

>
> 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.

left out the word 'times' in the description

value = <stored value> * 10^(<scale factor> * -1>)

123.45 = 12345 * 10^-2

Ann