You are here: Function Reference > Time Functions > Using the Time Zone Functions

Using the Time Zone Functions

The TimeZone and TimeZone2TimeZone functions are not available on mainframe platforms like z/OS. They are only available on Windows and UNIX platforms.

These functions use the International Components for Unicode (ICU) library. The ICU system time zones are derived from the tz database (also known as the Olson database) available at...

ftp://elsie.nci.nih.gov/pub

This is the data used across much of the industry, including by UNIX systems.

The ICU time zone functionality supports

Standard time zones, such as Eastern Standard Time (EST), Central Standard Time (CST), and so on.
Time zone IDs defined in the standard Olson data used by UNIX systems. These time zone IDs use the following format:

continent/city or ocean/city

For example, America/Los_Angeles is an ID for Pacific Standard Time.

Custom time zones based on Greenwich Mean Time (GMT), in this format:

"GMT[+|-]hh[[:]mm]")

Using the Time Zone Functions

See Also