TZCONVERT

Try it

When to use it

When should I use TZCONVERT instead of adding a fixed offset manually?

Use TZCONVERT whenever you need to account for daylight saving time. A fixed offset like +1 or -5 breaks twice a year; TZCONVERT uses IANA zone rules so the result is always correct regardless of DST transitions.

What happens if the target zone observes daylight saving time on that date?

TZCONVERT automatically applies the correct offset for the exact instant, so the output reflects DST if it is in effect — no manual adjustment is needed.

When should I use TZCONVERT versus TZDIFF?

Use TZCONVERT when you need the actual local time in another zone. Use TZDIFF when you only need the numeric hour difference between two zones.

Use cases

Show a Tokyo market open in London time

Convert a UTC timestamp to a customer's local zone

Used in

operations · hr · finance

Syntax

TZCONVERT(zoned,target_zone)