BIN
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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