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.
How to Use the Unix Timestamp Converter
- Paste a Unix timestamp (10 or 13 digits) and click 'Timestamp → Date'.
- Or type a date like 2026-10-02 12:00 and click 'Date → Timestamp'.
- Use 'current timestamp' to grab the epoch value for right now.
- Copy the result into your code, query, or API payload.
Why Use Our Unix Timestamp Converter?
- Auto-detects seconds vs milliseconds — no more 1970 dates from mixing them up.
- UTC + local time — see both, so timezone bugs don't bite.
- Bidirectional — timestamp to date and date to timestamp.
- Developer-friendly — free, instant, private.
Common Use Cases
- Debugging API responses: Paste the mystery 13-digit number from a JSON payload and see instantly whether it's milliseconds or seconds — no console needed.
- Log forensics: Convert batches of epoch values from server logs into readable times to reconstruct exactly when an incident started.
- Writing SQL migrations: Generate the epoch for a cutoff date, or convert stored epoch columns to dates with FROM_UNIXTIME / to_timestamp.
- Scheduling and cron jobs: Compute the timestamp for a future launch moment and sanity-check what an existing cron expression will actually fire at.
- JavaScript interop: Translate between Date.now() milliseconds and the seconds your backend, JWT library, or Redis TTL expects.
Unix Timestamp Converter vs Alternatives
- epochconverter.com: The long-running classic with a loyal following — but a dated, ad-heavy page and no auto-detect: you must tell it whether your value is seconds or milliseconds. Ours detects automatically and shows UTC + local together.
- unixtimestamp.com: Clean and fast for the basics. It lacks auto-detection and the date-to-timestamp direction in one view; this page does both directions on the same input.
- Python / JS one-liners:
datetime.fromtimestamp()ornew Date(ms)are instant if you're already in a REPL. For a one-off paste from a log file, opening a page is faster than opening a terminal. - Doing it in your head: Dividing by 31,536,000 gets you the year — and nothing else. Use the tool for anything you need to be right about.
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.