---
title: uuid_timestamp_micros() | Tiger Data Docs
description: Extract a Postgres timestamp with microsecond precision from a version 7 UUID
---

Since [2.23.0](https://github.com/timescale/timescaledb/releases/tag/2.23.0)

Extract a [PostgreSQL timestamp with time zone](https://www.postgresql.org/docs/current/datatype-datetime.html) from a UUIDv7 object. `uuid` contains a millisecond unix timestamp and an optional sub-millisecond fraction.

Unlike [`uuid_timestamp`](/docs/reference/timescaledb/uuid-functions/uuid_timestamp/index.md), the microsecond part of `uuid` is used to construct a PostgreSQL timestamp with microsecond precision.

Unless `uuid` is known to encode a valid sub-millisecond fraction, use [`uuid_timestamp`](/docs/reference/timescaledb/uuid-functions/uuid_timestamp/index.md).

![UUIDv7 structure with microsecond-precision timestamp](/docs/_astro/uuidv7-structure-microseconds.BBrmloq3.svg)

## Samples

```
SELECT uuid_timestamp_micros('019913ce-f124-7835-96c7-a2df691caa98');
```

Returns something like:

```
uuid_timestamp_micros
-------------------------------
 2025-09-04 10:19:13.316512+02
```

## Arguments

The syntax is:

```
SELECT uuid_timestamp_micros(
    uuid = <uuid>
);
```

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

## Returns

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