About the Database Time Zone Files

Two time zone files are included in a subdirectory of the Oracle home directory. The time zone files contain the valid time zone names.

cisco certification malaysia

The following information is also included for each time zone:

• Offset from Coordinated Universal Time (UTC)
• Transition times for Daylight Saving Time
• Abbreviations for standard time and Daylight Saving Time

checkpoint certification malaysia

The default time zone file is ORACLE_HOME/oracore/zoneinfo/timezlrg_11.dat. A smaller time zone file with fewer time zones can be found in ORACLE_HOME/oracore/zoneinfo/timezone_11.dat.

aws certification malaysia

To view the time zone names in the file being used by your database, use the following query:

SELECT * FROM V$TIMEZONE_NAMES;

virtualization training courses malaysia