§ Oracle兼容-函数-CAST()函数


§ 1. 语法

CAST(expr AS VARCHAR(N))
1

§ 2. 定义和用法

在原生 CAST() 函数的基础上,增加了在语法层面对VARCHAR(N)类型的支持。

§ 3. 示例

greatsql> SELECT CAST('greatsql' AS VARCHAR(10)), CAST('greatsql' AS VARCHAR(5));
+---------------------------------+--------------------------------+
| CAST('greatsql' AS VARCHAR(10)) | CAST('greatsql' AS VARCHAR(5)) |
+---------------------------------+--------------------------------+
| greatsql                        | great                          |
+---------------------------------+--------------------------------+
1 row in set, 1 warning (0.00 sec)

greatsql> SHOW WARNINGS;
+---------+------+-----------------------------------------------+
| Level   | Code | Message                                       |
+---------+------+-----------------------------------------------+
| Warning | 1292 | Truncated incorrect CHAR(5) value: 'greatsql' |
+---------+------+-----------------------------------------------+
1
2
3
4
5
6
7
8
9
10
11
12
13
14

扫码关注微信公众号

greatsql-wx