Unix Timestamp / Date Converter
Convert Unix/Epoch timestamps to human dates — or dates to timestamps. Built for developers. Zero ads.
…
Unix Timestamp
seconds or ms
Looks like milliseconds.
Timezone
Converted
Common timestamps — click to convert
Milestones
Developer Quick Reference
JavaScript
Seconds:
Ms → Date:
Sec → Date:
Date.now()/1000|0Ms → Date:
new Date(ms)Sec → Date:
new Date(s*1000)
Python
Now:
To date:
UTC:
time.time()To date:
datetime.fromtimestamp(ts)UTC:
datetime.utcfromtimestamp(ts)
SQL
MySQL:
PG:
SQLite:
FROM_UNIXTIME(ts)PG:
to_timestamp(ts)SQLite:
datetime(ts,'unixepoch')
What is Unix time?
Seconds since
1970-01-01 00:00:00 UTC (the Unix epoch). Timezone-independent. Milliseconds = seconds × 1000.