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