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

# timeSeriesTimeRanges

> timeSeriesTimeRanges 表函数返回表 `db_name.time_series_table` 所使用的时间范围表，其中该表使用 TimeSeries 表引擎。

`timeSeriesTimeRanges(db_name.time_series_table)` - 返回表 `db_name.time_series_table` 所使用的 [time ranges](https://clickhouse.com/docs/zh/reference/engines/table-engines/integrations/time-series.md#time-ranges-table) 表，
其中表 `db_name.time_series_table` 的表引擎为 [TimeSeries](https://clickhouse.com/docs/zh/reference/engines/table-engines/integrations/time-series.md) 引擎，例如：

```sql theme={null}
CREATE TABLE db_name.time_series_table ENGINE=TimeSeries TIME RANGES INNER UUID '01234567-89ab-cdef-0123-456789abcdef'
```

以下查询是等价的：

```sql theme={null}
SELECT * FROM timeSeriesTimeRanges(db_name.time_series_table);
SELECT * FROM timeSeriesTimeRanges('db_name.time_series_table');
SELECT * FROM timeSeriesTimeRanges('db_name', 'time_series_table');
```

> [!NOTE]
>
> 仅当启用了 `store_time_ranges` 设置时，才会存在 *time ranges* 表。
> [版本](https://clickhouse.com/docs/zh/reference/engines/table-engines/integrations/time-series.md#schema-versioning) 为 7 及更早的表会将 `min_time` 和 `max_time` 列保留在
> [tags](https://clickhouse.com/docs/zh/reference/engines/table-engines/integrations/time-series.md#tags-table) 表中。
