Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
format_string(strfmt [, obj1 [, ...] ])
strfmt
: ASTRING
expression.objN
:STRING
or numeric expressions.
A STRING
.
> SELECT format_string('Hello World %d %s', 100, 'days');
Hello World 100 days