TO_BIN

Converts a value (<expression>) of type INTEGER or BIGINT to its equivalent two’s complement binary representation.

Syntax

TO_BIN(<expression>)

Parameters

Parameter	Description	Supported input types
`<expression>`	A value expression evaluating to `INTEGER` or `BIGINT` that should be converted.	`INTEGER`, `BIGINT`

Return Type

TEXT

Returns NULL if the input is NULL

Remarks

The function returns the binary representation of the input number as a text string. Negative numbers are represented using two’s complement notation. Leading zeros are omitted, but the output is at least one digit long.

Example

The following examples convert integer values to their binary representations:

SELECT TO_BIN(5) as result

result text
101

Rows: 1Execution time: 6.08ms

SELECT TO_BIN(-1) as result

result text
11111111111111111111111111111111

Rows: 1Execution time: 5.58ms

SELECT TO_BIN(0) as result

result text
0

Rows: 1Execution time: 5.09ms

SELECT TO_BIN(NULL) as result

result text null
NULL

Rows: 1Execution time: 5.74ms

SUBSTRING, SUBSTR

TO_OCT

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Remarks

Example

​Syntax

​Parameters

​Return Type

​Remarks

​Example

Syntax

Parameters

Return Type

Remarks

Example