Unix Timestamp Converter

Convert a Unix timestamp into a readable UTC date and time.

Inputs

Unix Timestamp (seconds)

Name this scenario

Saved Scenarios

— select 2+ to compare

ISO Date (UTC)

2018-01-18T01:30:22.000Z

Year

2,018

Month

Day

Weekday

Thursday

Spark says

Formula

Date = Epoch\ (1970\text{-}01\text{-}01\ UTC) + Timestamp\ seconds

Epoch: — The Unix reference point: midnight UTC, January 1, 1970

What is the Unix Timestamp Converter?

Unix time (epoch time) counts seconds since midnight UTC on January 1, 1970 — a compact, timezone-independent way most systems and APIs internally represent a point in time. This converts that number back into a human-readable calendar date.

How to use it

1 Enter a Unix timestamp in seconds (not milliseconds — divide by 1000 first if your value has 13 digits).

Worked examples

Timestamp 1516239022

2018-01-18T01:30:22.000Z, a Thursday.

Try it

Limitations

•Displays UTC only — convert to your local timezone separately if needed, since the correct offset depends on your specific location and date (daylight saving, etc.).

Frequently asked questions

My timestamp has 13 digits, not 10 — why doesn't this work?

13-digit timestamps are in milliseconds, not seconds — divide by 1000 (drop the last 3 digits) before entering it here, since Unix time is conventionally measured in seconds.