Firebird Documentation IndexFirebird 2.5 Language Reference → Built-in functions and Variables
Firebird Home Firebird Home Prev: Trapping and Handling ErrorsFirebird Documentation IndexUp: Firebird 2.5 Language ReferenceNext: Context variables

Chapter 8: Built-in functions and Variables

Table of Contents

Context variables
CURRENT_CONNECTION
CURRENT_DATE
CURRENT_ROLE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TRANSACTION
CURRENT_USER
DELETING
GDSCODE
INSERTING
NEW
'NOW'
OLD
ROW_COUNT
SQLCODE
SQLSTATE
'TODAY'
'TOMORROW'
UPDATING
'YESTERDAY'
USER
Scalar Functions
Functions for Working with Context Variables
RDB$GET_CONTEXT()
RDB$SET_CONTEXT()
Mathematical Functions
ABS()
ACOS()
ASIN()
ATAN()
ATAN2()
CEIL(), CEILING()
COS()
COSH()
COT()
EXP()
FLOOR()
LN()
LOG()
LOG10()
MOD()
PI()
POWER()
RAND()
ROUND()
SIGN()
SIN()
SINH()
SQRT()
TAN()
TANH()
TRUNC()
Functions for Working with Strings
ASCII_CHAR()
ASCII_VAL()
BIT_LENGTH()
CHAR_LENGTH(), CHARACTER_LENGTH()
HASH()
LEFT()
LOWER()
LPAD()
OCTET_LENGTH()
OVERLAY()
POSITION()
REPLACE()
REVERSE()
RIGHT()
RPAD()
SUBSTRING()
TRIM()
UPPER()
Date and Time Functions
DATEADD()
DATEDIFF()
EXTRACT()
Type Casting Functions
CAST()
Functions for Bitwise Operations
BIN_AND()
BIN_NOT()
BIN_OR()
BIN_SHL()
BIN_SHR()
BIN_XOR()
Functions for Working with UUID
CHAR_TO_UUID()
GEN_UUID()
UUID_TO_CHAR()
Functions for Working with Generators (Sequences)
GEN_ID()
Conditional Functions
COALESCE()
DECODE()
IIF()
MAXVALUE()
MINVALUE()
NULLIF()
Aggregate Functions
AVG()
COUNT()
LIST()
MAX()
MIN()
SUM()

REVIEW STATUS

All sections from this point forward to the end of the chapter are awaiting technical and editorial review.

Here, the large collection of context variables, scalar functions and aggregate functions are described.

Prev: Trapping and Handling ErrorsFirebird Documentation IndexUp: Firebird 2.5 Language ReferenceNext: Context variables
Firebird Documentation IndexFirebird 2.5 Language Reference → Built-in functions and Variables