uuid_timestamp_micros()

Extract a Postgres timestamp with microsecond precision from a version 7 UUID

Since 2.13.0

Extract a timestamp with time zone from a UUIDv7 object. uuid contains a millisecond unix timestamp and an optional sub-millisecond fraction.

Unlike uuid_timestamp, the microsecond part of uuid is used to construct a timestamp with microsecond precision.

Unless uuid is known to encode a valid sub-millisecond fraction, use uuid_timestamp.

Samples

postgres=# 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.