CONV(N,from_base,to_base) : CONV : Math Numeric Functions MySQL TUTORIALS


MySQL TUTORIALS » Math Numeric Functions » CONV »

 

CONV(N,from_base,to_base)


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           |
+----------------+
row in set (0.00 sec)

mysql>
mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Math Numeric Functions
» CONV