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

1. 语法

  1. CAST(expr AS VARCHAR(N))

2. 定义和用法

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

3. 示例

  1. greatsql> SELECT CAST('greatsql' AS VARCHAR(10)), CAST('greatsql' AS VARCHAR(5));
  2. +---------------------------------+--------------------------------+
  3. | CAST('greatsql' AS VARCHAR(10)) | CAST('greatsql' AS VARCHAR(5)) |
  4. +---------------------------------+--------------------------------+
  5. | greatsql                        | great                          |
  6. +---------------------------------+--------------------------------+
  7. 1 row in set, 1 warning (0.00 sec)
  9. greatsql> SHOW WARNINGS;
  10. +---------+------+-----------------------------------------------+
  11. | Level   | Code | Message                                       |
  12. +---------+------+-----------------------------------------------+
  13. | Warning | 1292 | Truncated incorrect CHAR(5) value: 'greatsql' |
  14. +---------+------+-----------------------------------------------+

问题反馈

联系我们

扫码关注微信公众号

greatsql-wx