That's exactly what I was looking for.

Thank you.

--- In firebird-support@yahoogroups.com, "jft" <jft@...> wrote:
>
> Marc,
> To duplicate the FLOOR functionality, as CAST does an automatic
> rounding from floating point to integer, deduct 0.5 first.
>
> Try this in iSQL:
>
> select cast(6.999 - 0.5 as integer) from rdb$database /* gives 6 */;
> select cast(7.0 - 0.5 as integer) from rdb$database /* gives 7 */;
> select cast(7 - 0.5 as integer) from rdb$database /* gives 7 */;
> select cast(7.999 - 0.5 as integer) from rdb$database /* gives 7 */;
> select cast(8.0 - 0.5 as integer) from rdb$database /* gives 8 */;
>
> HTH,
> John
>
> > -------Original Message-------
> > From: marc_guillot <marc_guillot@...>
> > Subject: [firebird-support] I can't Backup/Restore a FB 2.01
database after creating it using a nScript
> > Sent: 15 Mar '07 05:30
> >
> > Hello.
> >
> > I creates a FB 2.01 using an Script (so I'am sure it's not
corrupted),
> > but it fails in backup/restore.
> >
> > gbak finishes Backup with no problem, but when restoring I get an
> > error of FLOOR (from ib_udf.dll) not registered.
> >
> > ¿ In FB 2.01 there is not possible to backup/restore a database that
> > uses udf's into their computed fields ?.
> >
> > I uses FLOOR udf, in a computed field who calculates the age of a
> > person (from his birthday), if somebody knows anyway to calculate it
> > without using udf's, i could avoid the problem.
> >
> > COMPUTED BY (cast(floor((current_date-cast(CLI_BIRTHDAY as
> > date))/365.25) as integer))
> >
> > Thank you.
> >
> >
>