[firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
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) F_MONTH (extracts the month from a pas

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
One last thing: I'm using FB 1.56. Thank you, Kevin From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton Sent: Friday, March 16, 2012 6:53 AM To: Firebird Support Subject: [firebird-support] UDF Question(s) Greetings,

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Jerry Sands
Extract(Day from MyDate) Extract(Month from MyDate) Extract(Year from MyDate) DateDiff(Day from FirstDate to SecondDate) (you can substitute Month, Week, Hour, Minute, Second, and MilleSecond as well. These are all in FB V2.1 I'm trying to eliminate the need for the FreeUDFLib so I can

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Jerry Sands
Oh, FB 1.56 - well good luck then - Jerry From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin Stanton Sent: Friday, March 16, 2012 9:00 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] UDF Question(s) One last

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Svein Erling Tysvær
>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) >F_MONTH (extracts the month from a passed da

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
Thanks for the info Jerry! From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Jerry Sands Sent: Friday, March 16, 2012 7:02 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] UDF Question(s) Oh, FB 1.56 - well good luck

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
ubject: RE: [firebird-support] UDF Question(s) >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 t

RE: [firebird-support] UDF Question(s)

2012-03-16 Thread Kevin Stanton
Svein Erling Tysvær Sent: Friday, March 16, 2012 7:05 AM To: 'firebird-support@yahoogroups.com' Subject: RE: [firebird-support] UDF Question(s) >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

Re: [firebird-support] UDF Question(s)

2012-03-16 Thread Iwan Cahyadi Sugeng
Try This : On Fri, Mar 16, 2012 at 8:52 PM, Kevin Stanton < kevin.stan...@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 rep

RE: [firebird-support] UDF Question(s) - a couple more

2012-03-16 Thread Kevin Stanton
Thanks! Kevin > -Original Message- > From: firebird-support@yahoogroups.com [mailto:firebird- > supp...@yahoogroups.com] On Behalf Of Iwan Cahyadi Sugeng > Sent: Friday, March 16, 2012 7:11 AM > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-suppo

Re: [firebird-support] UDF Question(s) - a couple more

2012-03-17 Thread Mark Rotteveel
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

RE: [firebird-support] UDF Question(s) - a couple more

2012-03-19 Thread Svein Erling Tysvær
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 take

RE: [firebird-support] UDF Question(s) - a couple more

2012-03-19 Thread Kevin Stanton
: Monday, March 19, 2012 1:44 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] UDF Question(s) - a couple more 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 fo