Then, lets back to my first approach:

secs bigint;
plustime time;

secs = (checkout-checkin)*84000;
--integer delta as seconds.

days = secs/84000; -- number of full days

plustime = cast('00:00' as time) + secs-(days*84000);
-- remainder time


Regards.

Ali

--- In firebird-support@yahoogroups.com, "d_dude_2003"
<d_dude_2003@...> wrote:

>
> cast(8.657 as integer) returns 9. WTF!
>
> --- In firebird-support@yahoogroups.com, Ali Gökçen <ali_gokcen@>
> wrote:
>