Thanx for your replies, it seems to me much clearer now :)

Martijn Tonies wrote:

>
>
> Hi,
>
> > 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
>
> http://en.wikipedia.org/wiki/Rounding
> <http://en.wikipedia.org/wiki/Rounding>
>
> Check for "round-to-even" or "bankers' Rounding".
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com <http://www.upscene.com>
> My thoughts:
> http://blog.upscene.com/martijn/ <http://blog.upscene.com/martijn/>
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> <http://www.databasedevelopmentforum.com>
>
>