toString

toString formats the input expression as a string. toString skips rows containing null values.

Syntax

Copy 
toString(expression)

Arguments

expression

An expression can be a field of any data type, a literal value like 14.62, or a call to another function that returns any data type.

Return type

String

Example

The following example returns the values from payDate (which uses the date data type) as strings.

Copy 
toString(payDate)

The following are the given field values.

Copy 
payDate
--------
1992-11-14T00:00:00.000Z
2012-10-12T00:00:00.000Z
1973-04-08T00:00:00.000Z

For these field values, the following rows are returned.

Copy 
1992-11-14T00:00:00.000Z
2012-10-12T00:00:00.000Z
1973-04-08T00:00:00.000Z