This article lists all scalar functions. For more details, click on the function name.
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.
Example
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
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
String functions can either return a string, such as LPAD, or a numeric value, such as LENGTH.
Exasol supports the following string functions:
Date/time functions
Date/time functions manipulate the DATE, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, and INTERVAL data types.
For functions that take a TIMESTAMP argument, a DATE datatype will be converted automatically to TIMESTAMP(0) and a string datatype will be converted automatically to TIMESTAMP(9).
Exasol supports the following date/time functions:
Geospatial functions
To analyze geospatial data, there are many functions available. For more information on geospatial data, refer to the Geospatial Data section.
Bitwise functions
Bitwise functions can compute bit operations on numerical values.
Conversion functions
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
JSON functions extract values from JSON objects stored as strings.
Other scalar functions
Functions that cannot be allocated to one of the other categories are listed here.
