Unix Timestamp Converter
Convert Unix timestamp (Epoch time) to human readable date and vice versa. Live current timestamp, supports seconds & milliseconds.
Current Unix Timestamp (Same Worldwide)
--
Unix Timestamp to Date
Date to Unix Timestamp
🔍 You Can Also Visit More Tools Categories
What is a Unix Timestamp?
A Unix timestamp, also called Epoch time, is the number of seconds that have passed since January 1, 1970 00:00:00 UTC (the Unix Epoch). Many systems also use milliseconds, which is the same value multiplied by 1000. Because it is a single integer, it is independent of timezones and easy to store, compare and sort. Databases like MySQL and MongoDB, APIs, logs and JWT tokens all use it.
Example: 1727074800 is 23 September 2024, 07:00:00 UTC, which is 12:30:00 IST.
What This Tool Does
- Converts a Unix timestamp (seconds or milliseconds) to a readable date.
- Converts a date and time to a Unix timestamp in seconds or milliseconds.
- Shows local time, UTC/GMT, ISO 8601 and relative time (for example, 2 hours ago).
- Shows the live current Unix timestamp, updated every second.
- Supports Local (browser), UTC/GMT and IST (Asia/Kolkata, UTC+5:30).
- Runs entirely in your browser. Nothing is sent to a server, and it works offline after the page loads.
Seconds vs Milliseconds
| Unit | Digits | Example | Used by |
|---|---|---|---|
| Seconds | 10 | 1727074800 | PHP time(), MySQL UNIX_TIMESTAMP(), Linux date +%s |
| Milliseconds | 13 | 1727074800000 | JavaScript Date.now(), Java System.currentTimeMillis() |
Example Timestamps
| Timestamp (seconds) | UTC | IST |
|---|---|---|
0 | 1 Jan 1970, 00:00:00 | 1 Jan 1970, 05:30:00 |
1000000000 | 9 Sep 2001, 01:46:40 | 9 Sep 2001, 07:16:40 |
1700000000 | 14 Nov 2023, 22:13:20 | 15 Nov 2023, 03:43:20 |
1727074800 | 23 Sep 2024, 07:00:00 | 23 Sep 2024, 12:30:00 |
2147483647 | 19 Jan 2038, 03:14:07 | 19 Jan 2038, 08:44:07 |
Get the Current Unix Timestamp in Code
| Language | Code (seconds) |
|---|---|
| JavaScript | Math.floor(Date.now() / 1000) |
| Python | int(time.time()) |
| PHP | time() |
| Java | Instant.now().getEpochSecond() |
| C# | DateTimeOffset.UtcNow.ToUnixTimeSeconds() |
| MySQL | SELECT UNIX_TIMESTAMP(); |
| Linux shell | date +%s |
Unix Timestamp in Excel
| Task | Formula (cell A1) |
|---|---|
| Timestamp to Excel date (UTC) | =(A1/86400)+DATE(1970,1,1) |
| Excel date to timestamp (UTC) | =(A1-DATE(1970,1,1))*86400 |
Format the result cell as Date/Time. Excel itself has no timezone, so add or subtract hours for your timezone, for example 5.5/24 for IST.
How to Convert a Unix Timestamp to a Date
- Enter your 10-digit or 13-digit timestamp in the input box.
- Select Seconds or Milliseconds.
- Click Convert to Date to see local time, UTC, ISO 8601 and relative time.
How to Convert a Date to a Unix Timestamp
- Pick the date and time.
- Choose the timezone: Local, UTC/GMT or IST.
- Choose the output unit: Seconds or Milliseconds.
- Click Convert to Timestamp and copy the result.
Frequently Asked Questions
What is the difference between seconds and milliseconds timestamps?
A seconds timestamp has 10 digits (for example 1727074800) and is used by PHP, MySQL and Python. A milliseconds timestamp has 13 digits (for example 1727074800000) and is used by JavaScript and Java. Select the correct unit before converting.
Is a Unix timestamp the same in every timezone?
Yes. A Unix timestamp always counts from the UTC epoch, so it is the same worldwide. Only the human-readable date and time change with the timezone.
How do I get the current Unix timestamp?
The top of this page shows the live current timestamp, and you can copy it with one click. In JavaScript you can use Math.floor(Date.now() / 1000).
Does it support Indian Standard Time (IST)?
Yes. It supports Local (browser), UTC/GMT and IST (Asia/Kolkata, UTC+5:30). When converting a date to a timestamp, select IST to get the timestamp for Indian Standard Time.
Do Unix timestamps include leap seconds?
No. Unix time ignores leap seconds and treats every day as exactly 86,400 seconds.
What is the Year 2038 problem?
Systems that store the timestamp as a signed 32-bit integer can only count up to 2147483647, which is 19 January 2038, 03:14:07 UTC. After that the value overflows. Modern 64-bit systems are not affected.
Is my data private?
Yes. All conversions run locally in your browser, and no timestamp or date is sent to any server.