>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
