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: 1785384809Milliseconds: 1785384809454ISO: 2026-07-30T04:13:29.454Z

Epoch → Date

UTC
Thu, 30 Jul 2026 04:13:29 GMT
ISO 8601
2026-07-30T04:13:29.000Z
Local
Thu, Jul 30, 2026, 04:13:29
Offset
UTC+00:00
Relative
in 1 second

Date → Epoch

Seconds
1785384780
Milliseconds
1785384780000
In UTC
2026-07-30T04:13: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.