Unix Timestamp Converter (Epoch Converter)
See the current Unix timestamp ticking live, then convert any epoch time to a readable date or a date back to a timestamp. The converter detects whether a number is in seconds, milliseconds, microseconds or nanoseconds, works in any IANA time zone, and shows ISO 8601, RFC 2822, UTC, relative time, day of the year and ISO week. Paste a column of timestamps to convert them all at once, or copy the code to get the time in JavaScript, Python, SQL and more.
Free · No sign-up
How to use it
- Paste a timestamp in the Timestamp to date box.
- Check the unit the converter detected, or pick one.
- Choose a time zone to see the local date there.
- To go back, pick a date and time and copy the seconds or milliseconds.
Why use this tool
Live epoch clock
The current timestamp in seconds and milliseconds, with copy and pause.
Unit auto-detect
10 digits are read as seconds, 13 as milliseconds, 16 as microseconds and 19 as nanoseconds.
Every time zone
Pick any IANA zone; daylight saving time is applied for each date.
Many formats
ISO 8601, RFC 2822, UTC, relative time, day of year and ISO week.
Batch conversion
Convert a whole column of log timestamps and copy the table to a spreadsheet.
Code snippets
JavaScript, Python, Java, PHP, Go, C#, MySQL, PostgreSQL and shell.
What is a Unix timestamp?
A Unix timestamp (epoch time or POSIX time) is the number of seconds since 1 January 1970 at 00:00:00 UTC, the Unix epoch. It is the same number everywhere on Earth at the same moment, which is why servers, databases and APIs store time this way and only convert to a local time zone for display.
Unix time ignores leap seconds: every day is counted as exactly 86,400 seconds. Dates before 1970 have negative timestamps, so -1 is 31 December 1969 at 23:59:59 UTC.
| Timestamp | Date (UTC) |
|---|---|
| 0 | 1970-01-01 00:00:00 |
| 1000000000 | 2001-09-09 01:46:40 |
| 1700000000 | 2023-11-14 22:13:20 |
| 1767225600 | 2026-01-01 00:00:00 |
| 2147483647 | 2038-01-19 03:14:07 |
Seconds, milliseconds or nanoseconds?
Unix and most languages use seconds (10 digits today). JavaScript's Date.now() and Java's System.currentTimeMillis() use milliseconds (13 digits). Some databases and tracing tools use microseconds (16 digits) or nanoseconds (19 digits). Dividing by the wrong factor gives a date in 1970 or thousands of years in the future, so the converter reads the number of digits first.
The year 2038 problem
A signed 32-bit integer can hold at most 2,147,483,647, which is 19 January 2038 at 03:14:07 UTC. One second later such a counter overflows to a negative number and the date jumps back to 1901. Systems that store time in 64-bit integers, as modern ones do, are not affected.
Frequently asked questions
How do I convert a Unix timestamp to a date?
Paste it in the Timestamp to date box. The date appears at once in your time zone, in UTC and as ISO 8601.
What is the current Unix timestamp?
It is shown live at the top of the tool in seconds and milliseconds; press Copy to take it.
Is my timestamp in seconds or milliseconds?
Count the digits: 10 digits are seconds and 13 digits are milliseconds for dates in our time. The tool detects this for you.
How do I convert a date to a Unix timestamp?
Pick the date and time and the time zone; the tool shows the timestamp in seconds and milliseconds.
Does daylight saving time change the timestamp?
No. A timestamp is always UTC-based; only the local time shown for it changes with daylight saving time.
How do I convert a timestamp in Excel?
Use =A1/86400+DATE(1970,1,1) for UTC and format the cell as a date. For milliseconds divide by 86400000.
Related tools
Need something built?
Tell us what you want to create.
Tell us what you need built, from a simple website to a complete app, AI solution, automation, or custom system.