Subject Re: [ib-support] How to use UDF in Firebird??
Author Roland Turcan
<<< 3. 6. 2002 8:58 - mk_delphi "mk_delphi@..." >>>
m> DECLARE EXTERNAL FUNCTION F_YEAR
m> DATE
m> RETURNS INTEGER BY VALUE
m> ENTRY_POINT 'Year'
m> MODULE_NAME 'c:\programmi\firebird\udf\FreeUDFLib.dll';

In Firebird is implemented new function Extact for dates and times
part extracting.

Use this statement in SP:

Year=Extract(Year from Date_Field);

Or in Select:

Select Extract(Year from Data_Field) from My_table;

IMHO, external function for Year is useless.

--
Best regards, TRoland