Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Sep 29, 2023
Send us feedback
bin
Applies to: Databricks SQL Databricks Runtime
Returns the binary representation of expr.
expr
bin(expr)
expr: A BIGINT expression.
A STRING.
> SELECT bin(13); 1101 > SELECT bin(-13); 1111111111111111111111111111111111111111111111111111111111110011 > SELECT bin(13.3); 1101