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. Thanks! Kevin > -----Original Message----- > From: [email protected] [mailto:firebird- > [email protected]] On Behalf Of Iwan Cahyadi Sugeng > Sent: Friday, March 16, 2012 7:11 AM > To: [email protected] > Subject: Re: [firebird-support] UDF Question(s) > > Try This : > > On Fri, Mar 16, 2012 at 8:52 PM, Kevin Stanton < Kevin.Stanton@rdb- > solutions.com> wrote: > > > ** > > > > > > Greetings, > > > > I'm trying to eliminate the need for the FreeUDFLib so I can have the > > option of running Firebird 32-bit or 64-bit. > > > > I believe I'm down to 4 UDFs - are there any replacement for the following: > > > > F_DAY (extracts the day from a passed date) > > > Extract (Day from Table.Date) > > > > > F_MONTH (extracts the month from a passed date) > > > > Extract (Month from Table.Date) > > > F_YEAR (extracts the year from a passed date) > > > > Extract (Year from Table.Date) > > > F_AGEINDAYS (returns an integer with the number of days between two > > parameter dates) > > > > DateDiff(Day, Table.StartDate, Table.EndDate) (available in fb2.1 and > above) > > > Thanks in advance, > > > > Kevin > > > > ~~~~~~~~~~~~~ > > > > Kevin Stanton > > > > RDB Solutions > > > > P: 503-705-0834 > > > > F: 503-822-0178 > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -- > Iwan Cahyadi Sugeng > Interaktif Cipta Lestari > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ++++++++ > Yahoo! Groups Links > > >
