Convert epoch time to a readable date and back — local time and UTC. Perfect for logs and database timestamps.
Timezone bugs or timestamp headaches in your database?
I sort out Oracle date/timezone, migrations and data integrity. 18+ years, worldwide.
A Unix timestamp (epoch time) is the number of seconds since 00:00:00 UTC on 1 January 1970. Databases, logs and APIs store moments in time this way as a single number. This converter turns a timestamp into a readable date in both your local time and UTC, and turns any date back into a timestamp.
Classic Unix time is in seconds (10 digits today). JavaScript and many APIs use milliseconds (13 digits). Leave it on Auto and the tool detects which you pasted.
A timestamp is a single instant; how it reads as a clock time depends on timezone. The tool shows both so you can match your server or database.