Unix Timestamp Converter — Seconds / Milliseconds Online

工具介绍

A Unix timestamp counts seconds (or milliseconds) since 1970-01-01 00:00:00 UTC. It is the lingua franca of databases, logs, APIs, and cron jobs. This tool converts between seconds/milliseconds and human-readable dates, showing UTC, your local timezone, weekday, and ISO 8601 string.

怎么使用

1. Pick direction: timestamp → date, or date → timestamp
2. Enter the timestamp (auto-detects 10-digit sec / 13-digit ms) or pick a date
3. Output shows UTC and your local timezone; copy with one click

常见用例

• Decoding 1749120000 from a database into a readable date
• Verifying cron schedule execution times
• Cross-timezone collaboration: share timestamps, render in your TZ
• Storing ISO 8601 strings as compact timestamps

常见问题

Q: 10 or 13 digits?
A: 10 = seconds (covers 1970-2038). 13 = milliseconds (JS Date.now()). The tool auto-detects.

Q: Wrong time displayed?
A: Check timezone. We use your browser locale; China is UTC+8.

Q: 2038 problem?
A: 32-bit signed second timestamps overflow on 2038-01-19. Modern systems use 64-bit.

小贴士

MySQL: UNIX_TIMESTAMP() returns seconds, FROM_UNIXTIME() reverses.

JS: Math.floor(Date.now()/1000) for seconds; new Date(ts*1000) for Date.

Python: time.time() returns float seconds; datetime.fromtimestamp(ts, tz) reverses.