conv

description

Syntax

VARCHAR CONV(VARCHAR input, TINYINT from_base, TINYINT to_base) VARCHAR CONV(BIGINT input, TINYINT from_base, TINYINT to_base) 对输入的数字进行进制转换，输入的进制范围应该在[2,36]以内。

example

1. MySQL [test]> SELECT CONV(15,10,2);
2. +-----------------+
3. | conv(15, 10, 2) |
4. +-----------------+
5. | 1111            |
6. +-----------------+

8. MySQL [test]> SELECT CONV('ff',16,10);
9. +--------------------+
10. | conv('ff', 16, 10) |
11. +--------------------+
12. | 255                |
13. +--------------------+

15. MySQL [test]> SELECT CONV(230,10,16);
16. +-------------------+
17. | conv(230, 10, 16) |
18. +-------------------+
19. | E6                |
20. +-------------------+

keywords

1. CONV