TZ_OFFSET
TZ_OFFSET( timezone_region )
Section titled “TZ_OFFSET( timezone_region )”- timezone_region: This parameter specifies the time zone region for which you want to get the offset. The input should be a VARCHAR2 value containing the desired time zone region name, such as ‘America/New_York’ or ‘Europe/London’. If this parameter is NULL, the function returns the time zone offset of the system’s current session time zone.
Example
Section titled “Example”SELECT TZ_OFFSET('US/Eastern') from DUAL;Output
Section titled “Output”-04:00Explanation
Section titled “Explanation”In the example, the TZ_OFFSET function is used to get the time zone offset for ‘US/Eastern’. The function returns a string in the format ’[+|-] TZH:TZM’ or a time zone offset value. In the output, ‘-04:00’ signifies a timezone that is four hours behind UTC.