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.
format_string(strfmt [, obj1 [, ...] ])
Argumentsâ
strfmt
: A STRING
expression.objN
: STRING
or numeric expressions.A STRING
.
SQL
> SELECT format_string('Hello World %d %s', 100, 'days');
Hello World 100 days
Related functionsâ
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4