Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Sep 26, 2023
Send us feedback
format_string
Applies to: Databricks SQL Databricks Runtime
Returns a formatted string from printf-style format strings.
format_string(strfmt [, obj1 [, ...] ])
strfmt: A STRING expression.
strfmt
objN: STRING or numeric expressions.
objN
A STRING.
> SELECT format_string('Hello World %d %s', 100, 'days'); Hello World 100 days
format_number function