Specifying the Database Time Zone and Time Zone File

Oracle Database datetime and interval data types and time zone support make it possible to store consistent information about the time of events and transactions.

rooms

• Setting the Database Time Zone
  You can set the database time zone with the SET TIME_ZONE clause of the CREATE DATABASE statement.
• 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.
• Specifying the Database Time Zone File
  All databases that share information must use the same time zone data file.

dell emc certification malaysia

Setting the Database Time Zone

You can set the database time zone with the SET TIME_ZONE clause of the CREATE DATABASE statement.

• Set the database time zone when the database is created by using the SET TIME_ZONE clause of the CREATE DATABASE statement.

CompTIA certification malaysia

If you do not set the database time zone, then it defaults to the time zone of the host operating system.

You can change the database time zone for a session by using the SET TIME_ZONE clause of the ALTER SESSION statement.

citrix certification malaysia 2