Module conversion 

Functions

atof

ATOF(str) - ASCII to float

atoi

ATOI(str) - ASCII to integer

bin

BIN(n) - Convert to binary string

cast

CAST(value AS type) - SQL standard type conversion

convert

CONVERT(value, type) - MySQL-style conversion

format

FORMAT(number, decimals) - Format number with thousands separator

hex

HEX(n) - Convert to hexadecimal string

oct

OCT(n) - Convert to octal string

to_number

TO_NUMBER(str) - Convert string to number (int or float)

to_string

TO_STRING(value) / STR(value) - Convert to string