Timestamp Converter
Convert Unix epoch values to human-readable dates, or parse SQL timestamp strings. Get the exact SQL query for PostgreSQL, SQLite, and MariaDB.
Auto-detect: > 9999999999 treated as milliseconds, otherwise seconds
Accepts: YYYY-MM-DD HH:MM:SS, YYYY-MM-DDTHH:MM:SS, YYYY-MM-DD
Enter a value above to see conversions
Common Epoch Reference Values
Unix Epoch
0
1970-01-01T00:00:00Z
Y2K
946684800
2000-01-01T00:00:00Z
Y2K38 Overflow
2147483647
2038-01-19T03:14:07Z
Current Time
—
—