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 |