Subject Re: [firebird-support] Arithmetics problem (Firebird 1.0.3 WI-V6.2.972)
Author Milan Babuskov
semprolbat wrote:
> Why is it that
> select (1 / 100) from rdb$database;
> Returns 0 and not 0,01?

Because the result of operation on two integers is integer.

You can use:

1.00/100.00

or

use cast to cast values to appropriate type.

HTH
--
Milan Babuskov
http://fbexport.sourceforge.net