CONV

Syntax

CONV(N,from_base,to_base)

Description

Converts numbers between different number bases. Returns a string representation of the number N, converted from base from_base to base to_base.

Returns NULL if any argument is NULL, or if the second or third argument are not in the allowed range.

Current

The argument N is interpreted as an integer, but may be specified as an integer or a string. The minimum base is 2 and the maximum base is 62. 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.

< 11.4

The argument N is interpreted as an integer, but may be specified as an integer or a string. The minimum base is 2 and 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.

Some shortcuts for this function are also available: BIN(), OCT(), HEX(), UNHEX(). Also, MariaDB allows binary literal values and hexadecimal literal values.

Examples

SELECT CONV('a',16,2); +----------------+ | CONV('a',16,2) | +----------------+ | 1010 | +----------------+  SELECT CONV('6E',18,8); +-----------------+ | CONV('6E',18,8) | +-----------------+ | 172 | +-----------------+  SELECT CONV(-17,10,-18); +------------------+ | CONV(-17,10,-18) | +------------------+ | -H | +------------------+  SELECT CONV(12+'10'+'10'+0xa,10,10); +------------------------------+ | CONV(12+'10'+'10'+0xa,10,10) | +------------------------------+ | 42 | +------------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}