printf function

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

Returns a formatted string from printf-style format strings.

Syntax 

printf(strfmt[, obj1, ...])

Arguments

  • strfmt: A STRING expression.

  • objN: A STRING or numeric expression.

Returns

A STRING.

Examples 

> SELECT printf('Hello World %d %s', 100, 'days');
 Hello World 100 days