Subject | Re: [ib-support] How to use UDF in Firebird?? |
---|---|
Author | Roland Turcan |
Post date | 2002-06-03T07:01:11Z |
<<< 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
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