Purpose
This function converts character data to a VARCHAR string.
Note
This function is supported starting from OceanBase Database V4.3.5 BP1.
Syntax
TO_CHAR(character)
Parameters
character: the character data to be converted.
Return type
- Returns a
VARCHARvalue. - Returns
NULLif thecharactervalue isNULL.
Examples
SELECT TO_CHAR('Hello, World!'), TO_CHAR(NULL);
The return result is as follows:
+--------------------------+---------------+
| TO_CHAR('Hello, World!') | TO_CHAR(NULL) |
+--------------------------+---------------+
| Hello, World! | NULL |
+--------------------------+---------------+
1 row in set