---
title: state_at() | Tiger Data Docs
description: Determine the state at a given time
---

Since [1.15.0](https://github.com/timescale/timescaledb-toolkit/releases/tag/1.15.0)

Determine the state at a given time from a state aggregate.

## Samples

Create a state aggregate and determine the state at a particular time.

```
SELECT state_at(
  (SELECT state_agg(ts, state) FROM states_test),
  '2020-01-01 00:00:05+00'
);
```

Returns:

```
state_at
----------
START
```

## Arguments

The syntax is:

```
state_at(
  agg StateAgg,
  ts TIMESTAMPTZ
) RETURNS TEXT


state_at_int(
  agg StateAgg,
  ts TIMESTAMPTZ
) RETURNS BIGINT
```

| Name | Type        | Default | Required | Description                                                                                                       |
| ---- | ----------- | ------- | -------- | ----------------------------------------------------------------------------------------------------------------- |
| agg  | StateAgg    | -       | ✔        | A state aggregate created with [`state_agg`](/docs/reference/toolkit/state-tracking/state_agg/state_agg/index.md) |
| ts   | TIMESTAMPTZ | -       | ✔        | The time to get the state at                                                                                      |

## Returns

| Column | Type | Description |
| ------ | ---- | ----------- |
| state  | TEXT | BIGINT      |