Skip to main content

​
format

Returns a formatted string using the specified format string and arguments. Supported Signatures 
function format(varchar, $1) returns varchar
function format(varchar, $1, $2) returns varchar
function format(varchar, $1, $2, $3) returns varchar
function format(varchar, $1, $2, $3, $4) returns varchar
function format(varchar, $1, $2, $3, $4, $5) returns varchar
🔗 Official Documentation

​
format_number

Returns a formatted string using a unit symbol. Supported Signatures 
function format_number(bigint) returns varchar
function format_number(double) returns varchar
🔗 Official Documentation

​
parse_data_size

Parses string of format value unit into a number, where value is the fractional number of unit values. Supported Signatures 
function parse_data_size(varchar) returns decimal(38, 0)
🔗 Official Documentation

​
parse_presto_data_size

Parses string of format value unit into a number, where value is the fractional number of unit values. Supported Signatures 
function parse_presto_data_size(varchar) returns decimal(38, 0)
🔗 Official Documentation

​
typeof

Returns the name of the type of the provided expression. Supported Signatures 
function typeof($1) returns varchar
🔗 Official Documentation
⌘I