Parse, Format, and Epochs
TZ_FROM_UNIX
Converts a Unix timestamp into a zoned date/time.
Syntax
=TZ_FROM_UNIX(timestamp, zone, [unit], [format])Parameters
NameTypeDescription
Name
timestampTypenumber or range
DescriptionUnix timestamp to convert.
Name
zoneTypetext
DescriptionIANA time zone.
Name
unit?Typetext
DescriptionUse "s" for seconds or "ms" for milliseconds.
Name
format?Typetext
DescriptionOptional output preset or format pattern.
Returns
The local date/time in the selected zone.
Example
=TZ_FROM_UNIX(1780304400, "UTC")Result: 2026-06-01 09:00:00