Conversion functions

This topic describes the conversion functions that are supported by PolarDB-X.

PolarDB-X supports the following conversion functions.

Function Description Example
BINARY Converts a string to a binary string. SELECT BINARY "RUNOOB"; The following result is returned: -> RUNOOB
CAST(x AS type) Converts one data type to another. Execute the following statement to convert the STRING data type to the DATE data type. SELECT CAST("2017-08-29" AS DATE); The following result is returned: -> 2017-08-29

results matching ""

    No results matching ""