At 11:13 AM 24/02/2005 +0100, you wrote:

>Hello,
>
>I have performed this:
>- backed up my DB
>- reinstalled FB 1.5.2 on 1.5.0 (both SS, on linux Slackware 10. The
>1.5.0 was backed up by installation program)
>- I copied my own library udf_nd.so to the new installation (contains
>several functions, e.g. TS_FMT)
>- restored the DB
>
>Now, when I perform
>select '02/14/2005', ts_fmt('02/14/2005', '%Y-%m') from rdb$database;
>I get the error
>"arithmetic exception, numeric overflow, or string truncation"
>
>Please help me, what could be wrong ?

Well, the engine has no idea what data type or column name to return in the
second field.

Try supplying a CAST expression and a column name, e.g.

select
'02/14/2005',
CAST(ts_fmt('02/14/2005', '%Y-%m') AS CHAR(5)) AS field2
from rdb$database;

./hb