Skip to main content

Conversion

Function NameDescription
ARRAY_TO_STRINGReturns a string of the values from the input array, with the values separated by the specified delimiter string.
BINARY_STRINGConverts the input expression to a binary value.
CASTConverts a value of one data type to another data type. This function behaves similarly to the TO_<data_type> (i.e. TO_TIMESTAMP) functions.
CONVERT_FROMConverts a binary string from the given data type to a Dremio type.
CONVERT_REPLACEUTF8Converts a binary string to a UTF-8 value and replaces all characters that cannot be converted to UTF-8 with the specified replacement character.
CONVERT_TIMEZONEConvert timestamp to the specified timezone
CONVERT_TOConverts a value to a binary string of a supported data type.
ENCODEEncodes the input expression using the specified charSet character encoding.
FROM_HEXReturns a binary value for the given hexadecimal string
HASHReturns a hash value of the arguments. HASH does not return NULL, even for NULL inputs.
HASH64Returns 64-bit hash of input value, with optional seed.
HEXReturns the hexadecimal encoding of an expression.
STRING_BINARYReturns a string that represents the provided bytes. Escapes non-printable characters as hex values.
ST_FROMGEOHASHReturns the latitude and longitude coordinates of the center of the given geohash.
ST_GEOHASHReturns the corresponding geohash for the given latitude and longitude coordinates.
TOASCIIConverts a string that is encoded in the specified character set to UTF-8.
TO_CHARConverts the input expression to a character/string using the specified format.
TO_DATEConverts the input expressions to the corresponding date.
TO_HEXReturns a hexadecimal string for the given binary value.
TO_NUMBERConverts a string into a number (double) in the specified format.
TO_TIMEConverts the input expressions to the corresponding time.
TO_TIMESTAMPConverts the input expressions to the corresponding timestamp.
UNHEXConverts the hexadecimal number into the bytes represented by a number.