Conversion
Function Name | Description |
---|---|
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