Skip to main content
Version: 0.0.1

BIT_LENGTH

Categories: Binary

BIT_LENGTH

Returns the length of the bits of the input expression.

Syntax​

BIT_LENGTH(expression binary, varchar) → integer​

  • expression: A binary or varchar expression.

Examples

{{< codeheader "BIT_LENGTH example" >}}

SELECT BIT_LENGTH(1010)
-- 32

{{< codeheader "BIT_LENGTH example" >}}

SELECT BIT_LENGTH('DREMIO')
-- 48

{{< codeheader "BIT_LENGTH example" >}}

SELECT BIT_LENGTH('abc')
-- 24

{{< codeheader "BIT_LENGTH example" >}}

SELECT BIT_LENGTH(NULL)
-- None