Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

Data type conversion

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

Description

Data type conversion can be explicit by using custom functions, or implicit depending on context.

Explicit conversion

Currently, the following explicit data type conversion functions are available:

Implicit conversion

In some functions and operators, there will be an implicit data type conversion which is done internally, without any loss of information in the output. Examples include:

Other functions with type changes

There are a number of other functions which takes one data type as input, and returns another. These are not conversion functions as such, since the semantics of the functions inherently imply a loss of information. Examples include:

Specifically for DATE handling, functions are available, which use a non-DATE type as input or output: