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()