uuid_timestamp()

Extract a Postgres timestamp with time zone from a UUIDv7 object.

Expand image

uuid contains a millisecond unix timestamp and an optional sub-millisecond fraction. This fraction is used to construct the Postgres timestamp.

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

postgres=# SELECT uuid_timestamp('019913ce-f124-7835-96c7-a2df691caa98');

Copy

Returns something like:

uuid_timestamp
----------------------------
 2025-09-04 10:19:13.316+02

Copy