BIN

Return the binary representation of a number. This function converts a number to its binary string equivalent.

Syntax

BIN(N)

Description

Returns a string representation of the binary value of the given longlong (that is, BIGINT) number. This is equivalent to CONV(N,10,2). The argument should be positive. If it is a FLOAT, it will be truncated. Returns NULL if the argument is NULL.

Examples

SELECT BIN(12);
+---------+
| BIN(12) |
+---------+
| 1100    |
+---------+

See Also

• Binary literals

• CONV()

• OCT()

• HEX()

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