Perfect! – those work in 1.56. J



I have tried (quickly) the date2 – date1 and it does seem to return an
integer. More testing to do but all looks good.



Thanks for the help!

Kevin







From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of 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.

>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 date)
>F_YEAR (extracts the year from a passed date)
>F_AGEINDAYS (returns an integer with the number of days between two

parameter dates)

>One last thing: I'm using FB 1.56.
>
>Thanks in advance,

Are you saying that

EXTRACT(DAY FROM <Date>)
EXTRACT(MONTH FROM <Date>)
EXTRACT(YEAR FROM <Date>)
<Date2> - <Date1>

Doesn't work?

I assume you're using Dialect 3, I think Dialect 1 DATE = Dialect 3
TIMESTAMP.

HTH,
Set





[Non-text portions of this message have been removed]