Collections:
CONV() - Number Base Conversion
How to convert an integer from one number base to another using the CONV() function?
✍: FYIcenter.com
CONV(str, from_base, to_base) is a MySQL built-in function that converts an integer from one number base to another. For example:
SELECT CONV(1279, 10, 16), CONV('4FF', 16, 10); -- +--------------------+---------------------+ -- | CONV(1279, 10, 16) | CONV('4FF', 16, 10) | -- +--------------------+---------------------+ -- | 4FF | 1279 | -- +--------------------+---------------------+ SELECT CONV(1279, 10, 8), CONV('2377', 8, 10); -- +-------------------+---------------------+ -- | CONV(1279, 10, 8) | CONV('2377', 8, 10) | -- +-------------------+---------------------+ -- | 2377 | 1279 | -- +-------------------+---------------------+ SELECT CONV(1279, 10, 2), CONV('10011111111', 2, 10); -- +-------------------+----------------------------+ -- | CONV(1279, 10, 2) | CONV('10011111111', 2, 10) | -- +-------------------+----------------------------+ -- | 10011111111 | 1279 | -- +-------------------+----------------------------+
Reference information of the CONV() function:
CONV(str, from_base, to_base): mewstr converts an integer from one number base to another. Arguments, return value and availability: str: Required. The integer string in from_base base. mewstr: Return value. The converted integer string to_base base. Available since MySQL 4.0.
Related MySQL functions:
⇒ COS() - Cosine Trigonometric Value
⇐ CEILING() - Rounding up to Integer
2023-12-19, 214🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...