Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E17118-04 |
|
|
PDF · Mobi · ePub |
TZ_OFFSET
returns the time zone offset corresponding to the argument based on the date the statement is executed. You can enter a valid time zone region name, a time zone offset from UTC (which simply returns itself), or the keyword SESSIONTIMEZONE
or DBTIMEZONE
. For a listing of valid values for time_zone_name
, query the TZNAME
column of the V$TIMEZONE_NAMES
dynamic performance view.
Note:
Time zone region names are needed by the daylight saving feature. These names are stored in two types of time zone files: one large and one small. One of these files is the default file, depending on your environment and the release of Oracle Database you are using. For more information regarding time zone files and names, see Oracle Database Globalization Support Guide.The following example returns the time zone offset of the US/Eastern time zone from UTC:
SELECT TZ_OFFSET('US/Eastern') FROM DUAL; TZ_OFFS ------- -04:00