Subject RE: [firebird-support] UDF Question(s)
Author 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 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