bin function

Applies to: Databricks SQL Databricks Runtime

Returns the binary representation of expr.

Syntax

bin(expr)

Arguments

• expr: A BIGINT expression.

Returns

A STRING.

Examples

> SELECT bin(13);
 1101
> SELECT bin(-13);
1111111111111111111111111111111111111111111111111111111111110011
> SELECT bin(13.3);
 1101

Related functions