Convert a Unix timestamp back into a calendar date and time.
Dividing by the seconds in a day separates the date from the time, then the day count is walked forward through years and months. Applying the offset afterwards gives local time. Timestamps are always UTC, so the offset must be applied at display time rather than stored, which is what keeps records correct across daylight saving changes.
Unix Timestamp
Days = ⌊timestamp ÷ 86,400⌋; the remainder gives the time within the day
Days = ⌊timestamp ÷ 86,400⌋; the remainder gives the time within the day Dividing by the seconds in a day separates the date from the time, then the day count is walked forward through years and months. Applying the offset afterwards gives local time.
Timestamps are always UTC, so the offset must be applied at display time rather than stored, which is what keeps records correct across daylight saving changes.
This calculator takes 2 inputs: Unix timestamp, Local UTC offset. The pre-filled defaults are a realistic starting point — replace them with figures from your own environment for a result you can act on.