Skip Headers
Oracle® OLAP Expression Syntax Reference
Release 11.2

Part Number E23381-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.