Collections:
CONV() - Binary/HEX String and Integer Conversion
How to perform binary/hexadecimal string and integer conversion using the CONV() function?
✍: FYIcenter.com
CONV(N, from_base, to_base) is a MySQL built-in function that allows you to perform binary/hexadecimal string and integer conversion. For example:
SELECT CONV('FF', 16, 10), CONV('FF', 16, 2); -- +--------------------+-------------------+ -- | CONV('FF', 16, 10) | CONV('FF', 16, 2) | -- +--------------------+-------------------+ -- | 255 | 11111111 | -- +--------------------+-------------------+ SELECT CONV(255, 10, 2), CONV(255, 10, 16); -- +------------------+-------------------+ -- | CONV(255, 10, 2) | CONV(255, 10, 16) | -- +------------------+-------------------+ -- | 11111111 | FF | -- +------------------+-------------------+
Reference information of the CONV() function:
CONV(in, from_base, to_base) : out 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. Arguments, return value and availability: in: Required. The input number in from_base base. out: Return value. The output number in to_base base. Available since MySQL 5.7.
⇒ ELT() - String at Given Index
⇐ CONCAT_WS() - Concatenation with Separator
2023-11-13, 224🔥, 0💬
Popular Posts:
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 Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
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 Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...