TZ_OFFSET function in Oracle

TZ_OFFSET is one of the vital Date/Time functions of Oracle. It is used to get the time zone offset of a value. The TZ_OFFSET function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax:

TZ_OFFSET ( timezone )

Parameters:
timezone: It is used to specify a valid time zone name.

Example 1:

TZ_OFFSET('US/Michigan')

Output:

 ‘-05:00'