---
title: Bit functions
description: Bitwise SQL functions for Analytics Engine.
image: https://developers.cloudflare.com/core-services-preview.png
---

> Documentation Index  
> Fetch the complete documentation index at: https://developers.cloudflare.com/analytics/llms.txt  
> Use this file to discover all available pages before exploring further. 

[Skip to content](#%5Ftop) 

# Bit functions

## bitAnd New

Usage:

```
bitAnd(a, b)
```

`bitAnd` returns the bitwise AND of expressions `a` and `b`.

Examples:

```
-- perform 0b1 & 0b11bitAnd(1, 3)-- extract the least significant bit of the integer value of double1bitAnd(toUInt8(double1), 1)
```

## bitCount New

Usage:

```
bitCount(a)
```

`bitCount` returns the number of bits set to one in the binary representation of `a`.

Examples:

```
-- get the number of 1 bits in the binary representation of the float `double1`bitCount(double1)-- get the number of 1 bits in the binary representation of `double1` as an integerbitCount(toUInt32(double1))-- select rows where at least 5 bits are 1SELECT * WHERE bitCount(double1) > 5
```

## bitHammingDistance New

Usage:

```
bitHammingDistance(x, y)
```

`bitHammingDistance` returns the number of bits that differ between `x` and `y`.

Examples:

```
-- returns zerobitHammingDistance(1, 1)-- returns 2bitHammingDistance(3, 0)
```

## bitNot New

Usage:

```
bitNot(a)
```

`bitNot` returns `a` with all bits flipped.

Examples:

```
bitNot(1)
```

## bitOr New

Usage:

```
bitOr(a, b)
```

`bitOr` returns the inclusive bitwise or of `a` and `b`.

Examples:

```
-- returns 3bitOr(1, 2)
```

## bitRotateLeft New

Usage:

```
bitRotateLeft(a, n)
```

`bitRotateLeft` rotates all bits in `a` left by `n` positions.

Examples:

```
-- returns 2bitRotateLeft(1, 1)-- returns 1bitRotateLeft(128, 1)
```

## bitRotateRight New

Usage:

```
bitRotateRight(a, n)
```

`bitRotateRight` rotates all bits in `a` right by `n` positions.

Examples:

```
-- returns 128bitRotateRight(1, 1)-- returns 3bitRotateRight(12, 2)
```

## bitShiftLeft New

Usage:

```
bitShiftLeft(a, n)
```

`bitShiftLeft` shifts all bits in `a` left by `n` positions.

Examples:

```
-- returns 2bitShiftLeft(1, 1)-- returns 0bitShiftLeft(128, 1)
```

## bitShiftRight New

Usage:

```
bitShiftRight(a, n)
```

`bitShiftRight` shifts all bits in `a` right by `n` positions.

Examples:

```
-- returns 0bitShiftRight(1, 1)-- returns 3bitShiftRight(12, 2)
```

## bitTest New

Usage:

```
bitTest(a, n)
```

`bitTest` returns the value of bit `n` in number `a`.

Examples:

```
-- returns 1bitTest(3, 1)-- return 0bitTest(2, 1)-- select rows where a particular bit is 1SELECT * WHERE bitTest(double1, 2)
```

## bitXor New

Usage:

```
bitXor(a, b)
```

`bitXor` returns the bitwise exclusive-or of `a` and `b`.

Examples:

```
-- returns 3bitXor(1, 2)-- returns 0bitXor(3, 3)
```

```json
{"@context":"https://schema.org","@type":"TechArticle","@id":"https://developers.cloudflare.com/analytics/analytics-engine/sql-reference/bit-functions/#page","headline":"SQL Reference · Cloudflare Analytics docs","description":"Bitwise SQL functions for Analytics Engine.","url":"https://developers.cloudflare.com/analytics/analytics-engine/sql-reference/bit-functions/","inLanguage":"en","image":"https://developers.cloudflare.com/core-services-preview.png","dateModified":"2026-04-23","publisher":{"@type":"Organization","name":"Cloudflare","url":"https://www.cloudflare.com/"},"isPartOf":{"@type":"WebSite","@id":"https://developers.cloudflare.com/#website","name":"Cloudflare Docs","url":"https://developers.cloudflare.com/"}}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"item":{"@id":"/directory/","name":"Directory"}},{"@type":"ListItem","position":2,"item":{"@id":"/analytics/","name":"Analytics"}},{"@type":"ListItem","position":3,"item":{"@id":"/analytics/analytics-engine/","name":"Workers Analytics Engine"}},{"@type":"ListItem","position":4,"item":{"@id":"/analytics/analytics-engine/sql-reference/","name":"SQL Reference"}},{"@type":"ListItem","position":5,"item":{"@id":"/analytics/analytics-engine/sql-reference/bit-functions/","name":"Bit functions"}}]}
```