Applies to:  CELONIS 4.7 

Description

TO_STRING converts INT input to STRING output.

Supported input column type: INT.

Output column type: STRING.

Syntax

TO_STRING ( table.column )

Null handling

If the input value is NULL, the output value is NULL as well.

Example


[1] Convert integers to strings. NULL input is also NULL in the output:

Query
Column1
TO_STRING ( "Table1"."Column1" )
Input
Table1
Column1 : INT
null
0
100
-200
-9223372036854775808
9223372036854775807
Output
Result
Column1 : STRING
null
'0'
'100'
'-200'
'-9223372036854775808'
'9223372036854775807'


See also:

  • No labels