DEV🕘Timestamp
Unix ⇄ Local time
Hint: 12+ digits are treated as milliseconds, otherwise seconds (an 11-digit value is treated as seconds; pad a 0 to force milliseconds). Editing either field updates the other.
Excel and VBA tutorials from basics to practice — use the tools above as you go.
Timestamp: Convert Between Unix and Local Time
Typical scenarios: ① turn Unix timestamps into readable time while debugging logs; ② align server and local time across time zones; ③ check the next run time after setting up a scheduled task.
How to use: paste or type a timestamp into the input box. The tool auto-detects 10-digit seconds vs 13-digit milliseconds and shows both UTC and your local time. Paste multiple lines — each is converted separately.
Notes: ① the timezone shown comes from your operating system, so users in different regions see different local times; ② negative numbers represent dates before 1970; ③ server logs are usually stored in UTC — don't confuse them with local display time.
Related Tools
← Home