Subject | Datatype Numeric rounding issues |
---|---|
Author | Martins Lazdans |
Post date | 2008-03-03T08:41:58Z |
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!
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!