On 16-3-2012 17:13, Kevin Stanton wrote:

> Greetings,
>
> I believe I'm down to just 3 UDFs and was wondering if there are any
> replacements for:
>
> F_ADDMONTH
> F_ADDYEAR
> F_AGEINMONTHS
>
>
> Also, is there a place where I can get a list of all functions for FB 1.56
> (and beyond)? I've taken a quick look but it's not jumping out at me.

Upgrading to Firebird 2.1 or higher would give you DATEADD and DATEDIFF
(see
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc.html
)

For F_ADDMONTH and F_ADDYEAR you could use the Firebird provided udfs
addMonth and addYear (see
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-udf.html
)

Mark

--
Mark Rotteveel