Subject | Re: [firebird-support] Numeric rounding? |
---|---|
Author | Ivan Prenosil |
Post date | 2005-01-05T10:09:25Z |
> I have a table (FB 1.5) with a field defined as Numeric(12,4). I useYes, use Dialect 3.
> this field in a store procedure with a variable defined as
> Numeric(12,2). When the field is selected into the variable it stores
> something like 123.4567 in the defined variable instead of rounding it
> to 123.46 as expected. Is there a way to make Firebird respect the
> variable definition in the stored procedure and round the number
> correctly?
Ivan