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
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