nowfound

Life & fun · March 11, 2025

Generate Version 7 UUID's for a Timestamp

I use UUIDv7's in multiple places as an efficient index in Postgres. When querying this data I usually need to be able to query between a time range so wanted to have a quick way to generate a reference ID that I could use in a BETWEEN query. All the simple, fast tools I found online were focused on generating bulk ids or converting from an ID to a timestamp rather than the other way around, so I wrote one myself. For example if I wanted to find everything that happened between 2025-03-11T13:00:00.000Z and 2025-03-11T13:59:59.999Z I can type in the timestamp, select earliest (or latest) to…

Generate Version 7 UUID's for a Timestamp launched on March 11, 2025 with 20 votes, #873 of 7,215 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 1 year on.

Visit uuidv7.org ↗Alternativestop 12% of March 2025

In plain words

This tool generates UUIDv7 identifiers from timestamps, allowing users to create reference IDs for time-range queries in PostgreSQL databases. Rather than converting existing IDs to timestamps or generating bulk UUIDs, it works in reverse—taking a timestamp input and producing the corresponding UUID that can be used in BETWEEN queries. It's designed for developers who index PostgreSQL data with UUIDv7s and need an efficient way to query records within specific time windows.

written from the facts on this page · September 2026

From the sources

Free online UUIDv7 generator. Generate date/time-based UUIDv7. Perfect for creating unique identifiers. Generate uuidv7 at specific timestamps.

Use the form above to generate a UUIDv7 for a specific date and time. Use earliest, random or latest to generate the smallest, random or largest possible values for a UUIDv7 generated at the specified timestamp. Note: This will output the UUIDv7, formatted timestamp and the timestamp in milliseconds. Or if you have access to a UUIDv7 and want to know what timestamp it represents, you can enter it here to extract that information. The timestamp will be in UTC. RFC 9562 defines a time-based UUID that includes an optional monotonically increasing counter. The table below splits the generated UUIDv7 string into it's component parts to give a clear visual indication of what each set of bits…from uuidv7.org

In the maker’s words, at launch

I use UUIDv7's in multiple places as an efficient index in Postgres. When querying this data I usually need to be able to query between a time range so wanted to have a quick way to generate a reference ID that I could use in a BETWEEN query. All the simple, fast tools I found online were focused on generating bulk…

Does a similar job

all alternatives →

More life & fun this month

the category →

Source: Show HN post ↗ · launch text quoted in part

Launched alongside, March 2025

the whole month →
  • Sider 5.0: Deep Research with Wisebase▲1,358

    Mimic Human Research & Save Findings in AI Knowledge Base

    AI · 2025 · sider.ai

  • MGX (Now Atoms)▲1,296

    Turn your ideas into products that sell

    AI · 2025 · atoms.dev

  • Aha▲1,152

    The world's first AI influencer marketing team

    AI · 2025 · ahacreator.com

  • Fluently▲976

    Start speaking English as well as your native language

    AI · 2025 · getfluently.app

  • TheySaid 2.0▲917

    Conversational AI surveys, interviews, user tests, polls

    AI · 2025 · theysaid.io

  • ツSupercut▲880

    Record your screen, share instantly, look like a PRO

    Growth · 2025 · supercut.ai