Subject RE: [firebird-support] Re: Doubts about function in
Author Alan McDonald
> Now i see they are working. I made a mistake when testing. I was
> using truncate(2.111, 2), thinking the function have a second
> parameter to specify the precision.
> Just for curiosity, how do you truncate numbers to a specif number
> of decimal digits?
> Something like this?
> cast(truncate(2.111 * 100) as double precision) / 100

There's an F_FIXEDPOINT UDF to do this