Timestamp Converter

What it's for

Turn a Unix timestamp into a readable date, or a date into a timestamp. Timestamps (seconds since 1 January 1970) appear in logs, databases, APIs and JWTs.

For example, when a log line or API response contains 1700000000 and you need to know when that actually was.

How to use it

Type or paste a timestamp in seconds, milliseconds, microseconds or nanoseconds, and the tool works out which from its length. Or type a date, such as 2026-10-01T12:00:00Z. You get Unix seconds and milliseconds, ISO 8601 in UTC, your local time, UTC and how long ago it was, each with a Copy button. Now fills in the current time.

The same moment is also given as a Windows FILETIME (also used for LDAP and Active Directory times), an Apple Cocoa or Core Data time and an Excel serial date. To read one of those, or the time inside an X (Twitter) or Discord Snowflake ID, choose it under Read as. A ULID or a MongoDB ObjectId is recognised by its shape, and the time it was made is shown.

Example

Type this:

1700000000

The tool reads it as seconds: 2023-11-14T22:13:20.000Z, which is Tuesday, 14 November 2023 at 22:13:20 UTC.

Good to know

Units are guessed from the number of digits, so a timestamp from very early 1970 could be misread; the tool says which unit it used. A date and time without a time zone is read as your local time, but a date on its own, such as 2026-10-01, is read as midnight UTC. Excel serial dates count days from 30 December 1899, which matches Excel for dates from March 1900 on (Excel counts a 29 February 1900 that never was); the old Mac 1904 system isn’t supported.