MySQL | CONVERT( ) Function

MySQL | CONV( ) Function

Last Updated : 21 Nov, 2019

The MySQL CONV() function is used for converting a number from one numeric base system to another. The value returned by the CONV() function is in the form of a string value. It accepts three parameters which are the value to be converted, the current numeric base system and the numeric base system to which the value needs to be converted.

The CONV() function treats a number as an unsigned number if a positive value is specified for the new base whereas, the CONV() function treats a number as a signed number if a negative new base is specified.

Syntax:

CONV(number, current_base, new_base)

Parameters Used:

number – It is used to specify the number who base needs to be changed.
current_base – It is used to specify the current base system of the number.
new_base – It is used to specify the desired base system in which the number needs to be converted.

Return Value:
The MySQL CONV() function returns a value in the desired base system specified by the user.

Supported Versions of MySQL:

MySQL 5.7
MySQL 5.6
MySQL 5.5
MySQL 5.1
MySQL 5.0
MySQL 4.1
MySQL 4.0
MySQL 3.23

Example-1: Implementing CONV() function to convert a number from numeric base system 10 to numeric base system 2.

SELECT CONV(20, 10, 2);

Output:

Example-2: Implementing CONV() function to convert a number from numeric base system 2 to numeric base system 10.

SELECT CONV(10100, 2, 10);

Output:

Example-3: Implementing CONV() function to convert a negative number from numeric base system 8 to numeric base system 10.

SELECT CONV(-6, 8, 10);

Output:

18446744073709551610

Example-4: Implementing CONV() function to convert a number from numeric base system 16 to numeric base system 10.

SELECT CONV('8D', 16, 10);

Output:

MySQL | CONVERT( ) Function

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

MySQL | CONVERT( ) Function

The MySQL CONVERT() function is used for converting a value from one datatype to a different datatype. The MySQL CONVERT() function is also used for converting a value from one character set to another character set. It accepts two parameters which are the input value and the type to be converted in

SQL Count() Function

In the world of SQL, data analysis often requires us to get counts of rows or unique values. The COUNT() function is a powerful tool that helps us perform this task. Whether we are counting all rows in a table, counting rows based on a specific condition, or even counting unique values, the COUNT()

MySQL | DECODE( ) Function

The MySQL DECODE() function is used for decoding an encoded string and return the original string. The MySQL DECODE() function returns empty strings if the encoded string is an empty string. The DECODE() function accepts two parameters which are the encoded string to be decoded and the password stri

MySQL | ENCODE( ) Function

The MySQL ENCODE() function is used for encoding a plain text string. The MySQL ENCODE() function returns a binary string which of the same size of the plain text string. The MySQL DECODE() function returns empty strings if the string passed is an empty string. The ENCODE() function accepts two para

COT() Function in MySQL

COT() function : This function in MySQL is used to return the cotangent of a specified number. If the specified number is 0, an error or NULL will be returned. In a right triangle, the cotangent of an angle is the length of it's adjacent side divided by the length of the opposite side. Similarly, th

MySQL CASE() Function

MySQL CASE function is a conditional statement that returns a value when the first condition is met. Once a condition is met, the CASE function does not check for other conditions. If no condition is met it returns the output in ELSE part. CASE Function in MySQLThe CASE Function in MySQL allows usin

MySQL | COMPRESS( ) Function

The MySQL COMPRESS() function is used for the compression of a string. The value returned by the COMPRESS() function is a binary string. The COMPRESS() function stores non-empty strings as a four-byte length of the uncompressed string, which is then followed by the compressed string. If the string e

MySQL COALESCE() Function

The MySQL COALESCE() function returns the first non-null value in a list of expressions. COALESCE function in MySQLThe COALESCE function in MySQL is used to get the first non-null value from a list of expressions. If all the values in the list are evaluated to NULL, then the COALESCE() function retu

PLSQL | CONCAT Function

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The CONCAT function allows you to concatenate two strings together. To CONCAT more than two values, we can nest

MySQL | BINARY Function

The MySQL BINARY function is used for converting a value to a binary string. The BINARY function can also be implemented using CAST function as CAST(value AS BINARY). The BINARY function accepts one parameter which is the value to be converted and returns a binary string. Syntax: BINARY value Parame