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

​
Syntax

TO_BIN(<expression>)

​
Parameters

ParameterDescriptionSupported 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: