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
