BIN

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}