> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# uuid_timestamp()

> Extract a Postgres timestamp from a version 7 UUID

export const PG = 'Postgres';

<Icon icon="tag" iconType="duotone" /> Since [2.23.0][tsdb-2.23.0]

Extract a {PG} timestamp with time zone from a UUIDv7 object.

`uuid` contains a millisecond unix timestamp and an optional sub-millisecond fraction.
This fraction is used to construct the {PG} timestamp.

![UUIDv7 microseconds][uuidv7-microseconds]

To include the sub-millisecond fraction in the returned timestamp, call
[`uuid_timestamp_micros`][uuid_timestamp_micros].

## Samples

```sql theme={"dark"}
SELECT uuid_timestamp('019913ce-f124-7835-96c7-a2df691caa98');
```

Returns something like:

```terminaloutput theme={"dark"}
uuid_timestamp
----------------------------
 2025-09-04 10:19:13.316+02
```

## Arguments

The syntax is:

```sql theme={"dark"}
SELECT uuid_timestamp(
    uuid = <uuid>
);
```

| Name   | Type | Default | Required | Description                                   |
| ------ | ---- | ------- | -------- | --------------------------------------------- |
| `uuid` | UUID | -       | ✔        | The UUID object to extract the timestamp from |

## Returns

| Column           | Type        | Description                                                                |
| ---------------- | ----------- | -------------------------------------------------------------------------- |
| `uuid_timestamp` | TIMESTAMPTZ | The timestamp extracted from the UUIDv7 object with millisecond precision. |

[tsdb-2.23.0]: https://github.com/timescale/timescaledb/releases/tag/2.23.0

[uuid_timestamp_micros]: /api-reference/timescaledb/uuid-functions/uuid_timestamp_micros

[uuidv7-microseconds]: https://assets.timescale.com/docs/images/uuidv7-structure-microseconds.svg