Conversion Functions

`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

Reference

SQL Functions

Conversion Functions

`format`

`format_number`

`parse_data_size`

`parse_presto_data_size`

`typeof`

​format

​format_number

​parse_data_size

​parse_presto_data_size

​typeof

`format`

`format_number`

`parse_data_size`

`parse_presto_data_size`

`typeof`