Hi Set should those functions be in FB 1.56? I will go test.
Thanks, Kevin From: [email protected] [mailto:[email protected]] On Behalf Of Svein Erling Tysvær Sent: Friday, March 16, 2012 7:05 AM To: '[email protected]' 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]
