Try:
SQL> select 1.0*1800/3600*10 from rdb$database;
=====================
5.0
or:
SQL> select 1800*10/3600 from rdb$database;
=====================
5
John

> -------Original Message-------
> From: d_dude_2003 <d_dude_2003@...>
> Subject: [firebird-support] how to calculate
> Sent: 04 Aug '07 22:16
>
> if i do SELECT (1800/3600)*10 FROM RDB$DATABASE the result is 0.
>
> how do i get 5?
>
>