Functions/Database & utility/bin

Database & utility Scalar

bin()

Converts the value to binary representation

Arguments & returns

6 overloads

`bin(value)`

Scalar

Overload link	`value`	Returns
#01	`BIGINT`	`VARCHAR`
#02	`HUGEINT`	`VARCHAR`
#03	`UBIGINT`	`VARCHAR`
#04	`UHUGEINT`	`VARCHAR`
#05	`VARCHAR`	`VARCHAR`
#06	`VARINT`	`VARCHAR`

Example

SELECT bin('Aa');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

SELECT bin(42);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3