Conversion

Function NameDescription

Converts the input expression to a binary value.

Converts a value of one data type to another data type. This function behaves similarly to the TO_<data_type> (i.e. TO_TIMESTAMP) functions.

Converts a binary string from the given data type to a Spice type.

Converts 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 timestamp to the specified timezone.

Converts a value to a binary string of a supported data type.

Explodes compound values into multiple rows. This function takes a LIST column and produces a lateral view (that is, an inline view that contains correlation referring to other tables that precede it in the FROM clause).

Returns a binary value for the given hexadecimal string.

Returns a hash value of the arguments. HASH does not return NULL, even for NULL inputs.

Returns the hexadecimal encoding of an expression.

Converts a string that is encoded in the specified character set to UTF-8.

Converts the input expression to a character/string using the specified format.

Converts the input expressions to the corresponding date.

Returns a hexadecimal string for the given binary value.

Converts a string into a number (double) in the specified format.

Converts the input expressions to the corresponding time.

Converts the input expressions to the corresponding timestamp.

Converts the hexadecimal number into the bytes represented by a number.

Last updated