Pages

Topics

Tools

↑↓navigate↵openescclose
Time, Text & CSS

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 tool
Is 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.

All SQL guides