PolarDB-X supports the following conversion functions.
| Function | Returns | Description | Example |
|---|---|---|---|
BINARY | Binary string | Converts a string to a binary string. | SELECT BINARY "RUNOOB"; → RUNOOB |
CAST(x AS type) | The specified type | Converts a value to the specified data type. | SELECT CAST("2017-08-29" AS DATE); → 2017-08-29 |
该文章对您有帮助吗？