Functions
TZPARSE
Parses an ISO/RFC-9557 timestamp into a zone-aware instant
Try it
When to use it
When should I use TZPARSE instead of TZDATETIME?
Use TZPARSE when your input is already a timestamp string from an API, log file, or user form. Use TZDATETIME when you are constructing a timestamp from separate date and time components.
What happens if the timestamp string has no timezone offset and I omit the zone argument?
TZPARSE will return an error because it cannot determine the correct instant without a zone. Always supply the zone argument when parsing timestamps that may lack a zone annotation.
Does TZPARSE accept both ISO 8601 and RFC-9557 formats?
Yes. It accepts plain ISO 8601 strings like 2026-07-14T09:00:00-04:00 as well as RFC-9557 strings with a bracketed IANA zone name like 2026-07-14T09:00:00-04:00[America/New_York].
Use cases
Parse a log timestamp that lacks a zone using a fallback zone
Parse an RFC-9557 timestamp with a bracketed IANA zone name
Used in
Syntax
TZPARSE(text,[zone])