|
| |
| 21. 11. 1. CONV(N,from_base,to_base): Converts numbers between different number bases |
|
|
Returns NULL if any argument is NULL. |
The minimum base is 2. |
The maximum base is 36. |
If to_base is a negative number, N is regarded as a signed number. |
Otherwise, N is treated as unsigned. |
CONV() works with 64-bit precision. |
|
mysql>
mysql> SELECT CONV('a',16,2);
+----------------+
| CONV('a',16,2) |
+----------------+
| 1010 |
+----------------+
1 row in set (0.00 sec)
mysql>
mysql>
|
|
| 21. 11. CONV | | 21. 11. 1. | CONV(N,from_base,to_base): Converts numbers between different number bases | | | | 21. 11. 2. | CONV(N,10,2) | | | | 21. 11. 3. | SELECT CONV(-17,10,-18); | | | | 21. 11. 4. | SELECT CONV(0xa,10,10); | | | | 21. 11. 5. | SELECT CONV('10',10,10); | | | | 21. 11. 6. | CONV(N,10,16). | | | | 21. 11. 7. | CONV(N,10,8) | | |
|