Unix timestamp 1,700,000,109 = November 14, 2023, 10:15:09 PM UTC (Tuesday). This is 2 years ago. Use the form below to convert any timestamp. Our calculator handles timestamps from -2,147,483,648 (1901) to 9,999,999,999 (2286) for 64-bit systems.
Notable Unix timestamps
| Timestamp | Date (UTC) | Event |
|---|---|---|
| 0 | Jan 1, 1970 00:00:00 | Unix epoch |
| 1,000 | Jan 1, 1970 00:16:40 | 16 minutes 40 seconds after epoch |
| 1,000,000 | Jan 12, 1970 13:46:40 | 1 millionth second |
| 946,684,800 | Jan 1, 2000 00:00:00 | Y2K (Y2K.0) |
| 1,000,000,000 | Sep 9, 2001 01:46:40 | Unix billionth second |
| 1,234,567,890 | Feb 13, 2009 23:31:30 | 1.234 billionth second |
| 1,700,000,000 | Nov 14, 2023 22:13:20 | Recent milestone |
| 2,147,483,647 | Jan 19, 2038 03:14:07 | Year 2038 problem (32-bit max) |
💡 Did you know? The Year 2038 problem affects 32-bit systems. Linux, macOS, and Windows on 64-bit hardware use 64-bit time_t, which won't overflow until approximately the year 292,277,026,596. Embedded systems, older databases, and some legacy code may still be vulnerable to 2038.
Frequently Asked Questions
Unix timestamp 1,700,000,109 = November 14, 2023, 10:15:09 PM (Tuesday) in UTC. The Unix epoch (timestamp 0) is January 1, 1970, 00:00:00 UTC. Timestamps count seconds from that point.
A Unix timestamp is the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC (the Unix epoch). For example, timestamp 1,700,000,000 = November 14, 2023. Unix timestamps are used by all major operating systems, file formats, and databases.
On January 19, 2038, at 03:14:07 UTC, 32-bit signed Unix timestamps will overflow to a negative value. Systems using 32-bit time_t will interpret the time as December 13, 1901. Most modern systems use 64-bit integers, which won't overflow until ~292 billion years from now.
Unix timestamp 1,000,000,000 = September 9, 2001, 01:46:40 UTC (a Sunday). It was celebrated as the 'Unix billionth second'. A timestamp of 1,000,000,000 is approximately 31.7 years.
Unix timestamp 0 = January 1, 1970, 00:00:00 UTC. This is the Unix epoch — the reference point for all Unix timestamps. Different operating systems and languages handle timestamps before the epoch (negative numbers) differently.
In Excel: =A1/86400 + DATE(1970,1,1) converts a Unix timestamp to a date. Or use TEXT(A1/86400 + DATE(1970,1,1), "yyyy-mm-dd hh:mm:ss") for a formatted string. For milliseconds: divide by 86400000 instead.
Unix timestamp 1,700,000,109 seconds = 1700000109000 milliseconds. JavaScript uses milliseconds, so divide by 1000 to get seconds. PHP and Python use seconds by default.
Unix time does not account for leap seconds. Every UTC day is exactly 86,400 seconds in Unix time, even on leap-second days. The most recent leap second was December 31, 2016.