Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 153 of 166
tz_offset::=
tz_offset
TZ_OFFSET
returns the time zone offset corresponding to the value entered based on the date the statement is executed. You can enter a valid time zone name, a time zone offset from UTC (which simply returns itself), or the keyword SESSIONTIMEZONE
or DBTIMEZONE
. For a listing of valid values, query the TZNAME
column of the V$TIMEZONE_NAMES
dynamic performance view.
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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|