<< UPPER() | FB 2.0 Language Reference | addDay >>

External functions (UDFs)

External functions must be "declared" (made known) to the database before they can be used. Firebird ships with two external function libraries:

• ib_udf – inherited from InterBase;
• fbudf – a new library using descriptors, present as from Firebird 1.0 (Windows) and 1.5 (Linux).

Users can also create their own UDF libraries or acquire them from third parties.

• addDay
• addHour
• addMillisecond
• addMinute
• addMonth
• addSecond
• addWeek
• addYear
• ascii_char
• dow
• dpower
• getExactTimestamp
• i64round
• i64truncate
• log
• lower
• lpad
• ltrim
• *nullif
• *nvl
• rand
• right
• round, i64round
• rpad
• rtrim
• sdow
• srand
• sright
• string2blob
• strlen
• substr
• substrlen
• truncate, i64truncate

See also:
User-defined function (UDF)?
External functions
UDFs callable as void functions
Threaded Server and UDFs
DECLARE EXTERNAL FUNCTION (incorporating a new UDF library)
ALTER EXTERNAL FUNCTION
DECLARE EXTERNAL FUNCTION
DROP EXTERNAL FUNCTION
Using descriptors with UDFs
Passing NULL to UDFs in Firebird 2
How to write an internal UDF function
Creating UDFs in Delphi
Firebird Null Guide: NULL <–> non-NULL conversions you didn't ask for

back to top of page
<< UPPER() | FB 2.0 Language Reference | addDay >>