printf
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
printf(strfmt[, obj1, ...])
Arguments
strfmt
: ASTRING
expression.objN
: ASTRING
or numeric expression.
Returns
A STRING
.
Examples
> SELECT printf('Hello World %d %s', 100, 'days');
Hello World 100 days