TOOLTIKI Lovable tool, really free
Date & time Timestamps

Microseconds to date converter

Value
Reading it as
UTC date and time 2023-11-14T22:13:20Z
Readable Tue, 14 Nov 2023 22:13:20 GMT
Unix seconds 1,700,000,000
Unix milliseconds 1,700,000,000,000
Windows FILETIME 133,444,736,000,000,000
.NET ticks 638,355,968,000,000,000
Excel serial 45,244.925926
Mac HFS+ seconds 3,782,844,800
Note
Local · JavaScript Dates cannot hold this precision
Advertisement
320 × 100

Converts a sixteen-digit microsecond timestamp into a date. PostgreSQL stores timestamps at microsecond resolution internally, and Python’s `time.time_ns()` divided by a thousand gives the same.

How to use the microseconds to date converter

1 Paste the value. Every other epoch is shown alongside the date.
2 Change what it is being read as if the number is from a different system.
3 All times are UTC — convert to your own zone separately if you need local time.

Microseconds show up most often when a value has come straight out of a database rather than through an application layer. PostgreSQL’s internal representation is microseconds since 2000-01-01, which is a different epoch again — a raw pg value needs the epoch shift as well as the unit change, and a value that decodes to 2053 is a Postgres-epoch number being read as a Unix one. Worth knowing that a JavaScript `Date` cannot hold microsecond precision at all: converting to one silently discards the last three digits, so a round trip through JavaScript loses resolution you may be relying on for ordering.

Questions

PostgreSQL internally, Python’s time functions, and anything derived from a high-resolution clock.

PostgreSQL — date/time types
Advertisement
300 × 250
Was this tool any good?
INTERNAL SIGNAL ONLY · WE USE IT TO FIND TOOLS WORTH REBUILDING