Timestamp Reference Points
Unix Epoch
0
January 1, 1970 00:00:00 UTC
Y2K
946684800
January 1, 2000 00:00:00 UTC
Year 2038 Limit
2147483647
Maximum 32-bit signed int timestamp
JS timestamp
Date.now()
Returns milliseconds — divide by 1000 for seconds
How to Use It
1
Open the tool
Go to Numbers & Dates and scroll to the Unix Timestamp Converter.
2
Paste a timestamp
Enter a Unix timestamp in seconds (10 digits) or milliseconds (13 digits). The human-readable date appears instantly.
3
Or enter a date
Pick a date and time from the date picker to get its Unix timestamp in both seconds and milliseconds.
4
Copy the result
Copy the timestamp or formatted date string for use in your code, SQL queries or logs.
Pro Tips
💡In JavaScript:
Math.floor(Date.now() / 1000) gives the current Unix timestamp in seconds.💡In SQL:
UNIX_TIMESTAMP() (MySQL) or EXTRACT(EPOCH FROM NOW()) (PostgreSQL) returns the current Unix timestamp.💡Always store timestamps in UTC. Convert to the user's local timezone only at display time to avoid timezone bugs.
Frequently Asked Questions
What is a Unix timestamp?
The number of seconds since January 1, 1970 00:00:00 UTC (the Unix epoch). It is timezone-independent and widely used in APIs, databases and log files.
Seconds or milliseconds?
A 10-digit number = seconds. A 13-digit number = milliseconds. JavaScript uses milliseconds (
Date.now()); Unix/Linux systems and most databases use seconds.What is the Unix epoch?
January 1, 1970 00:00:00 UTC. All Unix timestamps are counted from this point. Timestamps before this date are negative.
What is the Year 2038 problem?
32-bit signed integers max out at 2,147,483,647 = January 19, 2038. Systems using 32-bit
time_t will overflow. Modern 64-bit systems are not affected.Convert timestamps now
Open the Unix Timestamp Converter and translate any epoch timestamp to a readable date — free, instant, no login.
Open Timestamp Converter →