| Subject | Re: [firebird-support] Divide of an integer values |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2008-07-28T12:38:39Z |
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
www.firebirdsql.org/manual/qsg10-firebird-sql.html or google 'sql
integer division'. In short, to get 3,3333333333, you have to write
something like
select 10.0000000000 / 3 from rdb$database
Set
mariuszstefaniak wrote:
gives an integer as a result.
Take a look at the top of
www.firebirdsql.org/manual/qsg10-firebird-sql.html or google 'sql
integer division'. In short, to get 3,3333333333, you have to write
something like
select 10.0000000000 / 3 from rdb$database
Set
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