Functions
TZDBVERSION
IANA time-zone database version the engine is using
Try it
When to use it
When should I use TZDBVERSION instead of hardcoding the expected tzdb version?
Use TZDBVERSION in CI assertions and compliance checks so the formula automatically adapts when the engine is updated, rather than requiring a manual string update each time.
What does TZDBVERSION return, and how is it formatted?
It returns a string like "2025b" — the IANA time-zone database release tag the engine was compiled with, consisting of a four-digit year followed by a lowercase letter.
What happens if TZDBVERSION returns an older version than expected?
It means the engine binary has not yet been updated to the latest tzdb release; time-zone rules for recently changed regions may be stale, which can affect TZCONVERT and TZDATETIME results.
Use cases
Check whether the engine meets a minimum tzdb version
Validate tzdb version before a timezone conversion
Used in
Syntax
TZDBVERSION()