ToolNest logoToolNest.

Free Unix Timestamp Converter

Last updated: October 17, 2026

Quick answer: Convert Unix timestamps to dates and back instantly. Paste a 10-digit (seconds) or 13-digit (milliseconds) epoch value — our free converter auto-detects the format and shows the UTC and local date, or turn any date into a timestamp for your code, SQL, or API calls.

🔒 100% Private: Data never leaves your device.
Result appears here...

✓ Free forever  ·  ✓ No signup  ·  ✓ Tool inputs stay in your browser — never sent to our servers.

Try next: JWT Decoder · UUID Generator · Base64 Encoder / Decoder

How to Use the Unix Timestamp Converter

  1. Paste a Unix timestamp (10 or 13 digits) and click 'Timestamp → Date'.
  2. Or type a date like 2026-10-02 12:00 and click 'Date → Timestamp'.
  3. Use 'current timestamp' to grab the epoch value for right now.
  4. Copy the result into your code, query, or API payload.

Why Use Our Unix Timestamp Converter?

Common Use Cases

Unix Timestamp Converter vs Alternatives

Bottom line: for a quick one-off conversion, this page is the fastest correct option — auto-detection kills the #1 timestamp bug (seconds vs milliseconds), and both directions plus UTC/local live on one screen. Living in a REPL all day? The one-liners are fine too.

Frequently Asked Questions

What is a Unix timestamp?
The number of seconds since January 1, 1970 00:00:00 UTC. 10 digits = seconds, 13 digits = milliseconds (JavaScript's Date.now()).
Why does my date show 1970?
You probably fed milliseconds to a seconds-expecting function (or vice versa). This tool auto-detects and converts correctly.
Are Unix timestamps timezone-free?
Yes — a timestamp is one absolute moment. Timezones only matter when displaying it, which is why we show UTC and your local time.
What is the Year 2038 problem?
32-bit signed timestamps overflow on Jan 19, 2038. Modern 64-bit systems are unaffected — this tool handles full 64-bit ranges.
How do I convert a Unix timestamp in Python?
Use datetime.fromtimestamp(1798765432, tz=timezone.utc) for UTC, or datetime.fromtimestamp(...) for local time. Going the other way, datetime.now(timezone.utc).timestamp() gives you the current epoch. Watch out: fromtimestamp without a timezone silently uses your system timezone, which is the most common source of off-by-hours bugs.
Milliseconds vs microseconds vs nanoseconds — how do I tell them apart?
Count the digits: 10 = seconds, 13 = milliseconds (JavaScript Date.now()), 16 = microseconds, 19 = nanoseconds (Python time.time_ns()). Divide by 1,000 per extra three digits. This converter auto-detects 10- and 13-digit values, the two you'll meet in practice.
Can Unix timestamps be negative?
Yes — negative values represent dates before January 1, 1970 (e.g. -86400 is Dec 31, 1969). They work fine on 64-bit systems and in Python/JavaScript, but some databases and 32-bit APIs reject them, which is a classic legacy-system gotcha.
Why do APIs use 13-digit timestamps?
Because JavaScript's Date.now() returns milliseconds, and most web APIs are consumed from JavaScript. Feeding those 13 digits into a seconds-expecting function produces a date in the year 50,000+ — the single most common timestamp bug, and the one this tool's auto-detection exists to prevent.
Do Unix timestamps include leap seconds?
No — POSIX time deliberately pretends leap seconds don't exist, so every day is exactly 86,400 seconds. UTC wall-clock time and Unix time drift apart by the accumulated leap seconds (currently 27). If you need true astronomical accuracy, use TAI or a library like Astropy, not raw epoch math.
How do I convert epoch to date in SQL?
MySQL: FROM_UNIXTIME(ts) (and UNIX_TIMESTAMP(dt) to go back). PostgreSQL: to_timestamp(ts). SQLite: datetime(ts, 'unixepoch'). BigQuery: TIMESTAMP_SECONDS(ts). Note MySQL's version only handles seconds — divide millisecond values by 1,000 first.
What is the Unix timestamp right now?
As of October 2026 it is around 1.79 billion and climbs by one every second — click 'Use current timestamp' in the tool above for the exact live value, no math needed.
How do I convert a Unix timestamp to a date in Excel?
Enter =A1/86400+DATE(1970,1,1) with the timestamp in cell A1, then format the result cell as a date. The 86,400 converts seconds to days, since Excel counts days from January 1, 1900. Going the other way, =(A1-DATE(1970,1,1))*86400 turns a date back into a timestamp.
What date is Unix timestamp 1767225600?
January 1, 2026 at 00:00:00 UTC — exactly 1,767,225,600 seconds after the epoch began. Paste any 10-digit value into the converter above to check your own timestamps the same way.
Is it free?
Yes — free forever, no signup.