Scalar Functions

Scalar functions take a list of scalar arguments and return a single scalar value.

Different types of scalar functions include:

Numeric functions
String functions
Conversion functions
XML functions
Date and time functions

Scalar functions take one or more expression values as arguments and return a single result value for each row of data processed by a query. These functions can appear in most expressions, and are used most often in SELECT clauses and WHERE clauses.

Numeric Functions
Numeric functions are used with numeric values. Some numeric functions can also be used with interval and bigdatetime values. Examples of numeric functions include round () and sqrt ().
String Functions
String functions are used with STRING values and usually return a STRING value. Examples of string functions include left (), rtrim (), and replace ().
Conversion Functions
Conversion functions convert data values of various datatypes to the datatype specified by the function name.
XML Functions
There are special scalar functions which are designed to correctly handle XML data.
Date and Time Functions
Date and time functions set time zone parameters, date format code preferences, and define calenders.

Parent topic: CCL Functions