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]