TZABBR
Zone abbreviation at this instant (e.g. CEST), display only
Try it
When to use it
When should I use TZABBR instead of the full IANA zone name for display?
Use TZABBR when you need a compact label in a UI — such as a column header or tooltip — where space is limited. Keep the full IANA name in your data; use TZABBR only at the presentation layer.
What happens if two different zones share the same abbreviation, such as IST?
TZABBR returns the abbreviation that is correct for the specific zoned instant you pass, but the same string can mean India Standard Time, Irish Standard Time, or Israel Standard Time depending on the zone. Never use the returned abbreviation to identify or parse a zone — always keep the originating IANA name.
Does TZABBR change its output during daylight saving time?
Yes. A zone like America/New_York returns EST in winter and EDT in summer. TZABBR reflects whichever abbreviation is in effect at the exact instant of the zoned value you supply.
Use cases
Show the current zone abbreviation for a Berlin timestamp
Label a converted timestamp with its destination zone abbreviation
Used in
hr · operations
Syntax
TZABBR(zoned)