| Subject | RE: [firebird-support] how to calculate |
|---|---|
| Author | sasha |
| Post date | 2007-08-04T12:20:50Z |
>The easiest way is
> if i do SELECT (1800/3600)*10 FROM RDB$DATABASE the result is 0.
>
> how do i get 5?
>
SELECT (1800.0/3600)*10 FROM RDB$DATABASE
Notice floating point 1800.0 as opposed to 1800 int.
Sasha