Which means that

select mod(5.3*10, 2.0*10)/10.0 from rdb$database

possibly could work (I've never used MOD with Firebird).

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Gabor Boros
Sent: 9. november 2009 21:17
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] MOD question

Hi,

No way. MOD is working with integers.

http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-mod.html

Gabor

ionutz gorea írta:

> Hi,
>
> What's the "easiest way" to get the correct result for MOD(5.3, 2.0) from a Firebird 2.1?
>
> select mod(5.3, 2.0) from rdb$database returns 1 instead of 1.3
>
> Thanks
>
> Ionutz