Unix Timestamp Converter

Convert between Unix timestamps and human-readable dates, with timezone support. Runs entirely in your browser.

How to use:

  1. Enter a Unix timestamp (seconds or milliseconds) to convert to date
  2. Pick a date/time to convert to Unix timestamp
  3. Select a timezone to display results in (defaults to your browser local time)
  4. Copy any result with the copy button

Current time

Seconds: 1785344289Milliseconds: 1785344289800ISO: 2026-07-29T16:58:09.800Z

Epoch → Date

UTC
Wed, 29 Jul 2026 16:58:09 GMT
ISO 8601
2026-07-29T16:58:09.000Z
Local
Wed, Jul 29, 2026, 16:58:09
Offset
UTC+00:00
Relative
1 second ago

Date → Epoch

Seconds
1785344280
Milliseconds
1785344280000
In UTC
2026-07-29T16:58:00.000Z

The datetime-local input is interpreted in your browser's local timezone. The epoch values are timezone-independent (absolute).

SQL Formatter

Beautify messy SQL into clean, readable queries instantly.

CSV to SQL

Turn pasted CSV data into ready-to-run INSERT statements.

JSON ↔ SQL

Convert JSON arrays to SQL and SQL results back to JSON.

JOIN Visualizer

See how INNER, LEFT, RIGHT, FULL & CROSS joins differ.