Epoch / Unix Time Converter
100% Client-Side
Convertir Marca de Tiempo a Fecha
Hora Local
Hora UTC
ISO 8601
Tiempo Relativo
Convertir Fecha a Marca de Tiempo
Segundos (sec)
Milisegundos (ms)
Fragmentos de Código (Snippets)
What is a Unix Epoch Timestamp?
A Unix timestamp (Epoch time) counts the total number of seconds that have elapsed since January 1, 1970 00:00:00 UTC (known as the "Unix epoch"). It is timezone-independent and widely used across programming languages, databases (PostgreSQL, MySQL, MongoDB), and cloud APIs to store, sort, and compare dates precisely.
How to Convert Epoch to Human Date
- JavaScript:
new Date(1700000000 * 1000).toISOString() - Python:
datetime.datetime.fromtimestamp(1700000000, tz=datetime.timezone.utc) - SQL (PostgreSQL):
to_timestamp(1700000000) - SQL (MySQL):
FROM_UNIXTIME(1700000000) - C# (.NET):
DateTimeOffset.FromUnixTimeSeconds(1700000000).UtcDateTime
Common Unix Epoch Timestamp Milestones
| Epoch Timestamp | UTC Date & Time | Significance |
|---|---|---|
0 |
1970-01-01 00:00:00 UTC | Unix Epoch Origin |
1000000000 |
2001-09-09 01:46:40 UTC | 1 Billion Seconds milestone |
1700000000 |
2023-11-14 22:13:20 UTC | Recent 1.7B milestone |
2147483647 |
2038-01-19 03:14:07 UTC | 32-bit integer overflow (Year 2038 Problem) |