<< Click to Display Table of Contents >> Navigation:  SQL features > Firebird functions

Aggregate functions

LIST

 

Common functions
IIF
DECODE
NULLIF

 

Date functions

DATEADD(NUMBER DATE_PART to DATETIME): DATETIME
DATEDIFF(DATE_PART from DATETIME to DATETIME): NUMBER
DOW
EXTRACT(DATE_PART from DATETIME): DATETIME

 

String functions

SUBSTRING(VARCHAR from NUMBER to NUMBER): VARCHAR
ASCII_CHAR
CHAR_LENGTH
GEN_UUID
LPAD
LEFT
LOWER
OCTET_LENGTH
POSITION
REPLACE
REVERSE
RIGHT
RPAD
TRIM
UPPER

 

Mathematical functions

ABS
ACOS
ASIN
ATAN
ATAN2
BIN_AND
BIN_OR
BIN_SHL
BIN_SHR
BIN_XOR
CEILING
COS
COSH
COT
EXP
FLOOR
HASH
LN
LOG
LOG10
MAXVALUE
MINVALUE
MOD
PI
POWER
RAND
ROUND
SIGN
SIN
SINH
SQRT
TAN
TANH
TRUNC