Outdated Version

You are viewing an older version of this section. View current production version.


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).

BIN ( expression )

The function BINARY is not an alias for BIN.


  • expression: any valid numeric expression.

Return Type

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


memsql> select bin(1234);
| bin(1234)   |
| 10011010010 |

memsql> select bin(1234.5678);
| bin(1234.5678) |
| 10011010010    |