|Subject||RE: [firebird-support] UDF Question(s)|
|Author||Svein Erling Tysvær|
>Greetings,Are you saying that
>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,
EXTRACT(DAY FROM <Date>)
EXTRACT(MONTH FROM <Date>)
EXTRACT(YEAR FROM <Date>)
<Date2> - <Date1>
I assume you're using Dialect 3, I think Dialect 1 DATE = Dialect 3 TIMESTAMP.