Subject Re: [firebird-support] get float part of a number...
Author Milan Babuskov
Nairo Granados wrote:
> Hi have a simple question...
> How could I get the float part of a number?
>
> e.g. in: 1.45
> out: 45

You can use the floor UDF like this:

select number - floor(number) from ...


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