bit_length.md

description
Gets length of bits of the input expression.

BIT_LENGTH

Syntax

BIT_LENGTH(expression BINARY, VARCHAR) → BINARY

• expression: A binary or varchar expression

Examples

{% code title="BIT_LENGTH example" %}

SELECT BIT_LENGTH(1010)
-- 32

{% endcode %}

{% code title="BIT_LENGTH example" %}

SELECT BIT_LENGTH('SPICE')
-- 48

{% endcode %}

{% code title="BIT_LENGTH example" %}

SELECT BIT_LENGTH('abc')
-- 24

{% endcode %}

{% code title="BIT_LENGTH example" %}

SELECT BIT_LENGTH(NULL)
-- None

{% endcode %}