7/17/2026, 10:22:17 AM
Timezone: UTC
7/17/2026, 10:22:17 AM
This tool is part of these guided projects. Each project provides step-by-step instructions with checklists and all the tools you need in one place.
Tools you might need next
Test regular expressions online against sample text. See matches, capture groups, and flags in real time. Free regex debugger for JavaScript and PCRE patterns.
Format and beautify SQL queries. Supports SELECT, INSERT, UPDATE, DELETE, CREATE. Standard or Compact style. Free developer utility that runs locally in your
Parse cron expressions to human readable. Explain schedule. For cron jobs and scheduling. Free developer utility that runs locally in your browser — fast
Unix time counts seconds (or milliseconds) since January 1, 1970 00:00:00 UTC — the Unix epoch. Negative values represent dates before 1970.
Timestamp (seconds) = (Date − Epoch) ÷ 1000JavaScript Date.now() and many APIs use 13-digit millisecond timestamps. Unix CLI tools and some databases use 10-digit second timestamps. A millisecond value is 1,000× larger than its second equivalent.
ISO 8601 represents dates as YYYY-MM-DDTHH:mm:ss.sssZ (UTC) or with a numeric timezone offset (+05:30). It is the standard interchange format for APIs, logs, and databases.
Updated: July 2026
Convert a Unix timestamp from a JSON API response to a readable date.
→ 2024-01-01 00:00:00 UTC
A developer converts a millisecond timestamp from browser console output.
→ Same date — detected as milliseconds automatically
Convert a Unix epoch stored as an INTEGER in a database row to verify the record creation date.
→ 2023-01-01 00:00:00 UTC
A 10-digit timestamp is in seconds (valid through 2286). A 13-digit value is in milliseconds. Using the wrong unit shifts the date by roughly 1,000× — often to 1970 or far future.
Unix timestamps are always UTC. Displaying in local time adds your timezone offset. When comparing logs from different regions, convert all values to UTC first.
Convert between Unix epoch timestamps and readable dates in seconds or milliseconds. Essential for debugging API responses, log files, database records, and any system that stores time as a numeric epoch value.