Data type conversion
TO_FLOAT
Description: Converts a value to a floating-point number data type.
Syntax: TO_FLOAT ( table.column )
Example:
TABLE( TO_FLOAT("T"."AmountText") AS "Amount" )
TO_INT
Description: Converts a value into an integer numeric type.
Syntax: TO_INT ( table.column )
Example:
TABLE( TO_INT("T"."YearText") AS "Year" )
TO_STRING
Description: Converts a value into a string representation.
Syntax: TO_STRING ( table.column [ , FORMAT ( '%Y-%m-%d %H:%M:%S' ) ] )
Example:
TABLE( TO_STRING("T"."EventTime", FORMAT('%Y-%m-%d %H:%M:%S')) AS "EventTime Str" )