Firebird Documentation IndexFirebird 2.1 Language Ref. Update → External functions (UDFs)
Firebird Home Firebird Home Prev: UPPER()Firebird Documentation IndexUp: Firebird 2.1 Language Ref. UpdateNext: abs

Chapter 13: External functions (UDFs)

Table of Contents

abs
acos
addDay
addHour
addMilliSecond
addMinute
addMonth
addSecond
addWeek
addYear
ascii_char
ascii_val
asin
atan
atan2
bin_and
bin_or
bin_xor
ceiling
cos
cosh
cot
dow
dpower
floor
getExactTimestamp
i64round
i64truncate
ln
log
log10
lower
lpad
ltrim
mod
*nullif
*nvl
pi
rand
right
round, i64round
rpad
rtrim
sdow
sign
sin
sinh
sqrt
srand
sright
string2blob
strlen
substr
substrlen
tan
tanh
truncate, i64truncate

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

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

Prev: UPPER()Firebird Documentation IndexUp: Firebird 2.1 Language Ref. UpdateNext: abs
Firebird Documentation IndexFirebird 2.1 Language Ref. Update → External functions (UDFs)