Functions
TZOFFSET
Offset from UTC in minutes at this instant (DST-resolved)
Try it
When to use it
When should I use TZOFFSET instead of assuming a fixed offset for a time zone?
Use TZOFFSET whenever you need the actual offset at a specific instant. Fixed offsets like -5 or +1 break during DST transitions; TZOFFSET reads the offset already resolved inside the zoned value, so it is always accurate.
What happens if I call TZOFFSET on the same zone at two different times of year?
You may get different results. For example, New York returns -300 in winter (EST, UTC-5) and -240 in summer (EDT, UTC-4) because the offset shifts with daylight saving time.
When would I use TZOFFSET together with TZABBR?
Use them together when you need to display both the numeric offset and its abbreviation — for example, showing '−240 (EDT)' next to a timestamp in a financial or scheduling report.
Use cases
Get the UTC offset during US Eastern standard time
Compare offsets across two zones at the same instant
Used in
Syntax
TZOFFSET(zoned)