Tools / Unix timestamp converter
Unix Timestamp Converter
Convert Unix timestamps (epoch time) to readable dates and back. Seconds, milliseconds, microseconds and nanoseconds are detected automatically.
Free, no sign-up. Runs in your browser.
Current Unix time:
What is a Unix timestamp?
A Unix timestamp counts the seconds since 00:00:00 UTC on 1 January 1970, known as the Unix epoch. It’s the same number everywhere in the world, which makes it a convenient way to store times in databases, log files and APIs. Leap seconds aren’t counted.
Many systems use finer units. JavaScript, Java and many APIs use milliseconds (13 digits today), and some databases and logs use microseconds (16 digits) or nanoseconds (19 digits). This converter decides the unit from the number of digits, and you can see which it chose in the results.
Convert timestamps in Python, pandas and SQL
# Python
from datetime import datetime, timezone
datetime.fromtimestamp(1762166100, tz=timezone.utc) # timestamp to date
int(datetime(2025, 11, 3, tzinfo=timezone.utc).timestamp()) # date to timestamp
# pandas
pd.to_datetime(df["created"], unit="s", utc=True) # use unit="ms" for milliseconds
-- PostgreSQL
SELECT to_timestamp(1762166100);
SELECT EXTRACT(EPOCH FROM now());
-- MySQL
SELECT FROM_UNIXTIME(1762166100);
SELECT UNIX_TIMESTAMP();Working with dates over time? Our time series analysis tutorial covers resampling, rolling averages and forecasting in pandas.
FAQ
Why does my date come out in 1970 or far in the future?
The unit is probably wrong. A millisecond timestamp read as seconds lands tens of thousands of years in the future, and a seconds timestamp read as milliseconds lands in January 1970. Check the digit count: 10 digits is seconds, 13 is milliseconds.
Do timestamps have a time zone?
No. A Unix timestamp is always relative to UTC. The time zone only matters when you display it as a date, which is why the results show both UTC and your local time.
What is the year 2038 problem?
Systems that store seconds in a signed 32-bit integer can only count up to 2,147,483,647, which is 03:14:07 UTC on 19 January 2038. Modern systems use 64-bit integers and aren’t affected.
