Scalar functions receive an input value, and based on this input value the result is delivered. This function can be used with constant values, the column elements of a table (view) as well as with compound value expressions.
Scalar functions usually expect a special data type for their arguments. If it is not specified, then an implicit conversion of the data type is attempted, or an error message is displayed.
Numeric functions are given a numeric value as input and typically deliver a numeric value as output.
Exasol supports the following numeric functions:
String functions can either return a string (for example, LPAD) or a numeric value (for example, LENGTH).
Exasol supports the following string functions:
Date/Time functions manipulate the DATE, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, and INTERVAL data types.
Exasol supports the following date/time functions:
To analyze geospatial data, there are many functions available. For more information on geospatial data, refer to the Geospatial Data section.
Bitwise functions can compute bit operations on numerical values.
Conversion functions can be used to convert values to other data types.
Functions for Hierarchical Queries
The following functions can be used in combination with CONNECT BY queries.
JSON functions extract values from JSON objects stored as strings.
Functions that cannot be allocated to one of the above categories are listed here.