Date strings
ISO dates, SQL datetime, slash-separated dates, common written dates, date-only and time-only patterns.
Extract dates and timestamps from text, logs, JSON, CSV, or files. Convert detected values into readable dates, UTC, local time, ISO 8601, Unix timestamps, or custom formats.
| # / Line | Original value | Detected format | Converted date | UTC | Unix (seconds) | Relative | Action |
|---|---|---|---|---|---|---|---|
| Paste data or upload a file, then click “Extract & Convert”. | |||||||
ISO dates, SQL datetime, slash-separated dates, common written dates, date-only and time-only patterns.
Seconds, milliseconds, microseconds and nanoseconds, with magnitude-based detection.
Extract date values from server logs, messages, code snippets, JSON and other text.
Parse UTC markers, timezone offsets and convert results to a selected display timezone.
Copy results or export extracted values as CSV, JSON, or a converted text file.
Files and pasted text are processed locally in your browser and are not sent to EpochConvert.
YYYY year · YY 2-digit year · MM month · MMM short month name · MMMM full month name · DD day · ddd short weekday · dddd full weekday · HH 24-hour · hh 12-hour · mm minute · ss second · SSS millisecond · A AM/PM · Z timezone offset
Discord formats: Discord timestamp tags render dynamically in Discord. A generated Snowflake uses timestamp bits with worker, process, and sequence bits set to zero; it is an example timestamp-based ID, not an original Discord message ID.