TZ_OFFSET

TZ_OFFSET returns the time zone offset from Coordinated Universal Time (UTC).

Return Value

VARCHAR2

Syntax

TZ_OFFSET({ 'time_zone_name' | '{ + | - } hh:mi'
          | SESSIONTIMEZONE | DBTMEZONE
          }
         )

Arguments

time_zone_name is the name of a time zone.

hh:mm are hours and minutes. This argument simply returns itself.

SESSIONTIMEZONE returns the session time zone.

DBTIMEZONE returns the database time zone.

Examples

TZ_OFFSET('US/Eastern') returns the offset -04:00 during Daylight Savings Time.

TZ_OFFSET('EST') returns the offset -05:00.

TZ_OFFSET(DBTIMEZONE) returns the offset -07:00 for Mountain Standard Time.