Convert Timestamp to Date — Unix Timestamp to Date Converter, Date to Unix Timestamp Online

Frequently asked questions

How do I convert timestamp to date?

Paste a Unix timestamp (for example 1764581115) into the converter. It auto-detects seconds or milliseconds and shows the matching local and UTC date and time, plus ISO 8601 and RFC formats.

How do I convert Unix timestamp to date?

Enter the Unix epoch value in seconds or milliseconds. The Unix timestamp to date converter instantly displays human-readable date and time. You can also convert date to Unix timestamp using the date fields below.

What is the difference between seconds and milliseconds?

Unix timestamps in seconds are usually 10 digits (e.g. 1764581115). Milliseconds are usually 13 digits. This online timestamp to date converter auto-detects the unit, or you can force seconds, milliseconds, microseconds, or nanoseconds.

Can I convert date to Unix timestamp?

Yes. Choose year, month, day, hour, minute, and second (local or UTC). The date to Unix timestamp converter returns both seconds and milliseconds instantly.

Does this work like SQL, Python, Excel, or JavaScript converters?

Yes for the result: you get the same epoch ↔ datetime mapping developers use in SQL, Python, JavaScript, Excel, Google Sheets, Postgres, Oracle, BigQuery, and more. The page also includes common code examples for converting timestamp to date in those environments.

How to convert timestamp to date in code

Need the same conversion in SQL, Python, JavaScript, Excel, Postgres, Oracle, BigQuery, or Google Sheets? Use the online converter above for quick checks, then apply these patterns in your stack.

const ts = 1764581115; // seconds
const date = new Date(ts * 1000);
console.log(date.toISOString());

// date to unix timestamp
Math.floor(Date.now() / 1000);

from datetime import datetime, timezone
ts = 1764581115
print(datetime.fromtimestamp(ts, tz=timezone.utc))

# date to unix timestamp
print(int(datetime.now(tz=timezone.utc).timestamp()))

-- PostgreSQL / Postgres
SELECT to_timestamp(1764581115);
SELECT EXTRACT(EPOCH FROM NOW());

-- MySQL
SELECT FROM_UNIXTIME(1764581115);
SELECT UNIX_TIMESTAMP(NOW());

Excel (seconds → date):
=(A1/86400)+DATE(1970,1,1)

Google Sheets:
=EPOCHTODATE(A1)
or =(A1/86400)+DATE(1970,1,1)