Oracle教程 2023-03-22

Oracle 视图 V$TIMEZONE_NAMES 官方解释，作用，如何使用详细说明

V$TIMEZONE_NAMES视图可以用于查看不同的时区的显示的名称。它可以在多语言环境中被用户使用，按照下面的方式被查询：

SELECT TZNAME FROM V$TIMEZONE_NAMES;

查询出来的信息是一个VARCHAR2字段，它把实际的时区文件中的时区显示名称信息查询出来，例如查询出来的可能有如下字段信息：

Europe/Berlin，America/New_York等等。

使用V$TIMEZONE_NAMES视图，用户可以在各种语言下查看不同时区的显示名称，例如查看德国的时间：

SELECT TZNAME FROM V$TIMEZONE_NAMES WHERE tzname LIKE ‘Europe/%’;，

这样查询输出结果包括：Europe/Berlin,Europe/Rome 等等。

V$TIMEZONE_NAMES displays valid time zone names.

Column Datatype Description

Column	Datatype	Description
`TZNAME`	`VARCHAR2(64)`	Time zone region (for example, `US/Pacific`)
`TZABBREV`	`VARCHAR2(64)`	Corresponding daylight abbreviation (for example, `PDT`)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

TZNAME

VARCHAR2(64)

Time zone region (for example, US/Pacific)

TZABBREV

VARCHAR2(64)

Corresponding daylight abbreviation (for example, PDT)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data

分享到：