# clmm_sqrt_price_x96_to_tick

Inverts a Q64.96 sqrt(currency1/currency0) using Uniswap v4 TickMath floor semantics. It is deterministic and propagates NULL.

Canonical HTML: <https://determica.com/docs/functions/clmm_sqrt_price_x96_to_tick>

- Kind: scalar function
- Category: [Fixed-point and AMM math](/docs/category/fixed-point-and-amm-math.md)
- Tags: Clmm Math, Deterministic, Offline, Types

Inverts a Q64.96 sqrt(currency1/currency0) using Uniswap v4 TickMath floor semantics. It is deterministic and propagates NULL.

## Overload 1: clmm_sqrt_price_x96_to_tick(UINT256)

```sql
clmm_sqrt_price_x96_to_tick(UINT256)
```

Inverts a Q64.96 sqrt(currency1/currency0) using Uniswap v4 TickMath floor semantics. It is deterministic and propagates NULL.

- Kind: scalar
- Execution context: Offline
- Behavior: Transform
- Execution modes: Offline
- Input shape: Scalar Arguments
- Planning contract: Runtime
- Cardinality: One Per Input
- Determinism: Deterministic
- Return shape: Scalar
- Schema stability: Fixed
- Stability: Stable
- Side effects: None documented

### Inputs

- `sqrt_price_x96` (UINT256; required; positional) — UINT256 sqrt(currency1 / currency0) * 2^96 in [4295128739, 1461446703485210103287273052203988822378723970342).

### Returns

Greatest enclosing tick

INTEGER in [-887272, 887271]: the greatest tick whose TickMath square-root price is not greater than the input. NULL returns NULL; values outside the half-open range error.

- `tick` (INTEGER)

Greatest enclosing tick. INTEGER in [-887272, 887271]: the greatest tick whose TickMath square-root price is not greater than the input. NULL returns NULL; values outside the half-open range error.

### Examples

_Local SQL · Local_

```sql
SELECT clmm_sqrt_price_x96_to_tick(1771666303844022531703651649114164::UINT256) AS tick;
-- => [{"tick":200311}]
```

## Guidance

### Uniswap v4-compatible local math boundary

These generic helpers follow Uniswap v4 core TickMath, SqrtPriceMath, SwapMath, and TickBitmap conventions. Q64.96 square-root price means sqrt(currency1 / currency0) * 2^96, using raw token units.

- Use them as deterministic evidence about one hydrated pool state, price range, bitmap word, or swap step.
- They do not fetch state, resolve dynamic fees or hooks, cross ticks and update liquidity, iterate bitmap words, apply slippage policy, select routes, produce calldata, or return a complete executable quote.
- Pin onchain reads before use. The six-argument swap-step fee denominator and the bitmap result diagnostics are Determica extensions, not Uniswap v4 interfaces.

```sql
WITH bounds AS (
  SELECT
    clmm_tick_to_sqrt_price_x96(-60) AS sqrt_price_a_x96,
    clmm_tick_to_sqrt_price_x96(60) AS sqrt_price_b_x96
)
SELECT clmm_amount0_delta_x96(
  sqrt_price_a_x96,
  sqrt_price_b_x96,
  1000000::UINT256,
  false
) AS amount0
FROM bounds;
```

## Related functions

- [clmm_tick_to_sqrt_price_x96](/docs/functions/clmm_tick_to_sqrt_price_x96.md) — Alternative
- [clmm_bitmap_next_initialized_tick](/docs/functions/clmm_bitmap_next_initialized_tick.md) — See Also
- [clmm_swap_step_x96](/docs/functions/clmm_swap_step_x96.md) — See Also