Subject | RE: [firebird-support] UDF Question(s) |
---|---|
Author | Svein Erling Tysvær |
Post date | 2012-03-16T14:04:37Z |
>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>
Doesn't work?
I assume you're using Dialect 3, I think Dialect 1 DATE = Dialect 3 TIMESTAMP.
HTH,
Set