BIN
On this page
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.
Examples
SELECT BIN(1234);
+-------------+
| BIN(1234) |
+-------------+
| 10011010010 |
+-------------+SELECT BIN(1234.5678);
+----------------+
| BIN(1234.5678) |
+----------------+
| 10011010010 |
+----------------+Last modified: April 3, 2023