Timestamp Converter
Convert Unix timestamps and date strings in both directions, read a Discord, Twitter or Instagram snowflake id back to its instant, show the ISO week, day of the year and leap year, measure the exact gap between two instants, and copy JavaScript, Python, PostgreSQL or Go code for the moment.
Runs entirely in your browser — nothing you paste is uploaded.
Unix timestamp reference
quick reference- 1970-01-01T00:00:00Z
- The Unix epoch; every timestamp counts from this instant in UTC.
- 10 digits vs 13 digits
- Seconds and milliseconds. A 13-digit value is milliseconds and must be divided by 1000.
- 2038-01-19T03:14:07Z
- The 32-bit signed overflow limit, still relevant for stored int columns and embedded systems.
- ISO 8601
- 2026-11-16T05:00:00Z with a Z or offset; the safest format for APIs and logs.
- SQL DATETIME
- YYYY-MM-DD HH:MM:SS without a zone, so it is interpreted in the server's time zone.
- RFC 2822
- Mon, 16 Nov 2026 05:00:00 +0000 — the format used in email headers.
Frequently asked questions
answered below the toolIs my timestamp in seconds or milliseconds?
Ten digits is seconds and thirteen is milliseconds; divide a millisecond value by 1000 to get the same instant.
What happens after 2038?
A signed 32-bit seconds value overflows on 2038-01-19. Store 64-bit or millisecond values and the date keeps working.
How do I read the time in a Discord message id?
Shift the id 22 bits right and add the Discord epoch 1420070400000 ms. The snowflake panel does it for Discord, Twitter and Instagram, whose epochs and bit layouts differ.
Related SQL syntax guides
All SQL guidesSQLite: database is locked (SQLITE_BUSY) under concurrent writes
SQLite allows one writer. Set a busy timeout, switch to WAL, start write transactions as IMMEDIATE, and reduce to a single writer connection.
SQLMySQL: ERROR 1040 (HY000) Too many connections
The server is out of slots because pools are too large or leaking. Read the counters, size pools against replicas, then raise the limit.
SQLMySQL 8: Public Key Retrieval is not allowed over JDBC
The driver never sent the password. Use verified TLS, or allow key retrieval only where the network is trusted.
SQLPostgres: invalid input syntax for type uuid
An empty filter or a legacy id reaches a uuid parameter. Treat absent as no filter and validate before the query.