string function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Casts the value expr to STRING. This function is a synonym for cast(expr AS STRING). See cast function for details.

Syntax 

string(expr)

Arguments

  • expr: An expression that can be cast to STRING.

Returns

A STRING.

If expr is not a STRING, the result STRING is assigned the default collation. Otherwise, the result collation matches the collation of expr.

Examples 

> SELECT string(5);
 5

> SELECT string(current_date);
 2021-04-01