Subject Datatype Numeric rounding issues
Author Martins Lazdans
Hello!

I`m kinda confused about how Firebird rounds numeric datatypes. Here`s
an example:

SELECT CAST(3.6648 AS NUMERIC(9, 2)) FROM rdb$database
Results in: 3.66

SELECT CAST(3.6648 AS NUMERIC(9, 3)) FROM rdb$database
Results in: 3.665

My question: should`nt it result in 3.67 in first example? Tested on
`Firebird_2_1_0_17735-0_Win32` and `Firebird_2_0 `

Tried dialect 1 and 3 too

Thanks for your help!