Subject Re: [firebird-support] Divide of an integer values
Author Svein Erling Tysvaer
This is completely normal SQL, Marius - an integer divided by an integer
gives an integer as a result.

Take a look at the top of or google 'sql
integer division'. In short, to get 3,3333333333, you have to write
something like

select 10.0000000000 / 3 from rdb$database


mariuszstefaniak wrote:
> I'm executing query
> select 10 / 3 from rdb$database
> On results I have 3 instead 3,3333333333
> Without values after comma!
> Whats going on? Is this correct? How to force on server normal division
> operation?
> I have Firebird 2.1.1 and I'm connected to the server by IBExpert.
> regards
> MS