Oracle Database 11g: Managing Data in Different Time Zones

Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.3

Lesson Objectives

Oracle Database 11g: Managing Data in Different Time Zones

recognize the steps for managing time zones and time intervals.

recognize the steps for using datetime functions to manage dates and time in Oracle Database 11g.

display time zone offsets in a given scenario.

extract and return the value of a datetime field in a given scenario.