Subject | RE: [firebird-support] UDF Question(s) - a couple more |
---|---|
Author | Kevin Stanton |
Post date | 2012-03-16T16:13:30Z |
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
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-----following:
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of Iwan Cahyadi Sugeng
> Sent: Friday, March 16, 2012 7:11 AM
> To: firebird-support@yahoogroups.com
> 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
> >
> > 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
>
>
>