Scalar Functions

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
SELECT SIN(1);
SELECT LENGTH(s) FROM t;
SELECT EXP(1+ABS(n)) FROM t;

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.

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.

ST_*

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.