VulCode

Unix timestamp

Timestamp to a date in any time zone and back, with ISO 8601 and SQL.

For developers tools
Category
For developers
Price
free

The tool starts in your browser.

Everything is calculated in your browser. Nothing you type is sent to our server.

How to use it in three steps

The tool as a schematic with this page's example. Each step's number stands where you take it: in the fields, at the result or outside the tool.

Unix timestamp
What you enter
1767225600

  1. Enter a timestamp or a date.

  2. Pick a time zone.

What you get
2026-01-01T00:00:00.000Z Thu, 01 Jan 2026 00:00:00 GMT

  1. Copy the ISO 8601, HTTP or SQL form.

Eight timestamps and how the tool tells the unit

The same moment written in seconds, milliseconds, microseconds and nanoseconds. The tool tells the unit by the number of digits: up to 11 is seconds, up to 14 milliseconds, up to 17 microseconds, longer is nanoseconds.

TimestampExpected moment (UTC)What the tool returnsResult
Timestamp1767225600the example from the description, 10 digits
Expected moment (UTC)2026-01-01T00:00:00.000Z
What the tool returns2026-01-01T00:00:00.000Z, seconds
As expected
Timestamp176722560000013 digits from JavaScript
Expected moment (UTC)2026-01-01T00:00:00.000Z
What the tool returns2026-01-01T00:00:00.000Z, milliseconds
As expected
Timestamp176722560000000016 digits
Expected moment (UTC)2026-01-01T00:00:00.000Z
What the tool returns2026-01-01T00:00:00.000Z, microseconds
As expected
Timestamp176722560000000000019 digits
Expected moment (UTC)2026-01-01T00:00:00.000Z
What the tool returns2026-01-01T00:00:00.000Z, nanoseconds
As expected
Timestamp1 767 225 600with spaces
Expected moment (UTC)2026-01-01T00:00:00.000Z
What the tool returns2026-01-01T00:00:00.000Z, seconds
As expected
Timestamp-86400before 1970
Expected moment (UTC)1969-12-31T00:00:00.000Z
What the tool returns1969-12-31T00:00:00.000Z, seconds
As expected
Timestamp2147483648one second too many for 32 bits
Expected moment (UTC)2038-01-19T03:14:08.000Z
What the tool returns2038-01-19T03:14:08.000Z, seconds, beyond a 32-bit INT
As expected
Timestamptomorrowa word instead of a number
Expected moment (UTC)An error: a timestamp is a number
What the tool returnsA timestamp is a number, such as 1790000000.
As expected

8 of 8 cases as expected

Questions

Related tools

The tool does one job. If the same thing should happen automatically in your bot, server or system, we build it.

Missing a tool you need?

Tell us what you want to calculate or generate. We will tell you whether a tool is enough or an integration in your system fits better.