Quick access

Saved in this browser. Sign in to keep it on all your devices.

Unix Timestamp Converter

Epoch to date and date to epoch in any time zone. Seconds, milliseconds, microseconds and nanoseconds are detected for you.

Current Unix time

Your time · ()

Convert

or pick a date and time

The date and time above are read in this zone, and results are shown in it.

· ()

Enter a timestamp or a date to see it in every format.

Day
ISO week
Day of year
Leap year

This is after 19 January 2038, 03:14:07 UTC. Systems that store time as a signed 32-bit number can’t hold it.

Timestamps in code

LanguageCurrent timestampTimestamp → date

1 minute

60 s

1 hour

3,600 s

1 day

86,400 s

1 week

604,800 s

30 days

2,592,000 s

365 days

31,536,000 s

Version 1.1 Updated What's new

Release notes

  1. v1.1 Latest
    • Added an in-depth guide below the tool, written from what the tool actually does.

About the Timestamp Converter

A Unix timestamp counts the seconds since 1 January 1970 at 00:00 UTC. Computers use it to store a moment without time zone confusion. This converter shows the current time in your own time zone, turns any timestamp into ISO 8601, RFC 2822 and readable dates, and turns a date and time in any time zone back into a timestamp.

How to use it

  1. 1 Paste a timestamp. Seconds, milliseconds, microseconds and nanoseconds are detected from the number of digits.
  2. 2 Or pick a date, a time and a time zone to get its timestamp.
  3. 3 Copy any format, or see the same moment in other cities in the world clock.

Frequently asked questions

Is a timestamp in seconds or milliseconds?

Unix time is in seconds (10 digits today). JavaScript and many APIs use milliseconds (13 digits). Some databases and logs use microseconds (16) or nanoseconds (19). The converter detects all four, or you can pick the unit.

Does a Unix timestamp have a time zone?

No. It always counts from UTC, so the same timestamp is the same moment everywhere. The time zone is applied only when the timestamp is shown as a date.

Which time zone does the converter use?

It starts in your browser’s time zone, for example Asia/Dhaka (UTC+6) in Bangladesh. You can switch to any IANA time zone, and the result follows daylight saving time automatically.

How do I get the timestamp for a date in another time zone?

Choose the time zone first, then pick the date and time. The tool reads that wall-clock time in the chosen zone and gives you the matching Unix timestamp.

What is the year 2038 problem?

Systems that store Unix time as a signed 32-bit number overflow on 19 January 2038 at 03:14:07 UTC. Modern systems use 64-bit numbers, which last for billions of years.

What is the difference between ISO 8601 and RFC 2822?

ISO 8601 (2026-10-19T09:30:00+06:00) is used by APIs, JSON and databases. RFC 2822 (Mon, 19 Oct 2026 09:30:00 +0600) is used in email headers and older HTTP headers.

Get the current Unix timestamp in code

# Shell (Linux, macOS)
date +%s

// JavaScript: milliseconds, then seconds
Date.now()
Math.floor(Date.now() / 1000)

# Python
import time; int(time.time())

// PHP
time();

-- MySQL / PostgreSQL
SELECT UNIX_TIMESTAMP();
SELECT EXTRACT(EPOCH FROM now());

Convert a timestamp to a date in code

// JavaScript (expects milliseconds)
new Date(1767225600 * 1000).toISOString()

# Python
from datetime import datetime, timezone
datetime.fromtimestamp(1767225600, tz=timezone.utc)

// PHP
date('Y-m-d H:i:s', 1767225600);

-- MySQL / PostgreSQL
SELECT FROM_UNIXTIME(1767225600);
SELECT to_timestamp(1767225600);

All of these give 1 January 2026, 00:00 UTC. The most common bug is passing seconds to something that expects milliseconds, which gives a date in January 1970.

Unix time in Excel and Google Sheets

Spreadsheets count days from 1900, not seconds from 1970. To turn a Unix timestamp in A1 into a date, use =A1/86400 + DATE(1970,1,1) and format the cell as a date and time. For milliseconds, divide by 86,400,000 instead. To go the other way, use =(A1 - DATE(1970,1,1)) * 86400. The result is in UTC, so add or subtract hours for your time zone.

Useful timestamps to recognise

  • 0: 1 January 1970, 00:00:00 UTC, the Unix epoch.
  • 1,000,000,000: 9 September 2001, 01:46:40 UTC.
  • 1,767,225,600: 1 January 2026, 00:00 UTC.
  • 2,000,000,000: 18 May 2033, 03:33:20 UTC.
  • 2,147,483,647: 19 January 2038, 03:14:07 UTC, the largest signed 32-bit value.

A 10-digit number that starts with 17 is almost certainly a timestamp in seconds from the mid-2020s.

Epoch, POSIX time and UTC timestamps

Epoch time, Unix time and POSIX time all mean the same count of seconds since 1970-01-01 00:00 UTC. A “UTC timestamp” usually means the same thing, or an ISO 8601 string ending in Z. Unix time ignores leap seconds, so every day is exactly 86,400 seconds long, which keeps date maths simple.