TO_BIN

Reference material for the TO_BIN function

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