versioned_docs/version-2.0/sql-manual/sql-functions/numeric-functions/bin.md

---
{
    "title": "BIN",
    "language": "en"
}
---

## Description

Converts decimal numbers to binary text.

## Syntax

```sql
BIN(<a>)
```

## Parameters

| Parameter | Description |
| -- | -- |
| `<a>` | Decimal value to be converted |

## Return Value

The binary representation of the parameter `<a>`. When `<a>` is negative, the result is its 64-bit complement.

## Examples

```sql
select bin(0);
```

```text
+--------+
| bin(0) |
+--------+
| 0      |
+--------+
```

```sql
select bin(-1);
```

```text
+------------------------------------------------------------------+
| bin(-1)                                                          |
+------------------------------------------------------------------+
| 1111111111111111111111111111111111111111111111111111111111111111 |
+------------------------------------------------------------------+
```

```sql
select bin(123);
```

```text
+----------+
| bin(123) |
+----------+
| 1111011  |
+----------+
```