DQL functions grouped by category. For in-depth information on a specific function, select its name.
Aggregation functions compute results from a list of records.
String functions allow you to create expressions that manipulate text strings in a variety of ways.
Conversion and casting functions convert the expression or value from one data type to another type.
Functions that return a conditional result.
Functions that evaluate boolean expressions and test the presence of values.
Time functions return the decimal number for a particular time value, calculate the number of time units (days, months, years) between two dates, and allow to determine timestamps and timeframes, among others.
Functions related to a collection of items of the same data type stored at adjacent memory locations.
Functions that calculate the distance between numeric array expressions.
Functions related to IP addresses.
Hash related functions.
Bitwise operations performing on long expressions.
Functions executing mathematical calculations.
Functions that join records from subqueries.
Functions with a general purpose.