format_string function

Applies to: Databricks SQL Databricks Runtime

Returns a formatted string from printf-style format strings.

The function exploits the java.util.Formatter class with Locale.US. For details, see java.util.Formatter.

Syntax

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

Arguments

• strfmt: A STRING expression.
• objN: STRING or numeric expressions.

Returns

A STRING.

Examples

SQL

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

Related functions

• format_number function