toString - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

toString

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

Syntax

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.

toString(payDate)

The following are the given field values.

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.

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