Decode creation timestamps from Snowflake IDs, MongoDB ObjectIds, ULIDs, and UUIDv7, with selectable platform epochs.
DEVELOPER & CODE · LOCAL WORKBENCH · BROWSER WORKSPACE
Find the time in an ID. Choose the right epoch.
Decode creation timestamps from Snowflake IDs, MongoDB ObjectIds, ULIDs, and UUIDv7, with selectable platform epochs.
{ }
01 · IDENTIFIERDETECTS FOUR FORMATS
LOAD AN EXAMPLE
The epoch trap
Snowflakes store a count from a platform-specific start date. The wrong epoch can produce a plausible date that is still years off.
02 · DECODED TIMESTAMPSNOWFLAKE · 64-BIT
2024-01-24 03:38:08.084 UTC. This uses the selected platform epoch. If the ID came from another system, switch the epoch and compare; the wrong date may still look plausible.
FORMATSnowflake · 64-bitCREATED · UTC2024-01-24 03:38:08.084 UTCYOUR LOCAL TIME24 Jan 2024, 03:38:08AGE2.7 years ago
03 · ID STRUCTURE4 COMPONENTS
Timestamp bits417,232,513,427 ms
Top 41 bits, counted from the epoch below.
Epoch used2010-11-04 01:42:54.657 UTC
Platform-specific; choosing the wrong one still produces a plausible date.
Machine ID752
Node that generated the ID · 10 bits.
Sequence0
Counter within that millisecond · 12 bits.
This date reflects when the ID was generated, using that machine’s clock. It may differ from the time a record was saved.
◎
Runs in this browser. The ID is decoded in this browser with no lookup or network request. Its embedded time reflects the ID generator clock, not necessarily when a database record was saved.
Decode creation timestamps from Snowflake IDs, MongoDB ObjectIds, ULIDs, and UUIDv7, with selectable platform epochs. Results update as you adjust inputs and stay in this browser.
