BIN

Returns a string representation of the binary value of N, where N is a longlong (BIGINT) number.

This is equivalent to CONV(N,10,2).

Syntax

BIN ( expression )

Note

The function BINARY is not an alias for BIN.

Arguments

  • expression: any valid numeric expression.

Return Type

A string containing numeric value, in binary. Float values are truncated. Returns NULL if expression is NULL.

Examples

SELECT BIN(1234);
+-------------+
| BIN(1234)   |
+-------------+
| 10011010010 |
+-------------+
SELECT BIN(1234.5678);
+----------------+
| BIN(1234.5678) |
+----------------+
| 10011010010    |
+----------------+

Last modified: April 3, 2023

Was this article helpful?