Functions/Database & utility/to_binary
Database & utility Scalar

to_binary()

Converts the value to binary representation

Alias of bin()

Arguments & returns

6 overloads

to_binary(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

1 more ↓
to_binary example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

More examples

to_binary example 2
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  bin(42);