I know about Extract but the fact is I am nota able
to use UDF!!!
The UDF is the standard FreeUDFLib from C.Valde,
The firebird is the last...
So why want work? damn

--- In ib-support@y..., Roland Turcan <rolo@s...> wrote:
> <<< 3. 6. 2002 8:58 - mk_delphi "mk_delphi@y..." >>>
> 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