Oracle Database 11g: Managing Time Zones and Datetime Functions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


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
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.3

Lesson Objectives

Oracle Database 11g: Managing Time Zones and Datetime Functions

  • recognize the steps for managing time zones and time intervals.
  • recognize the steps for using datetime functions to manage dates and times 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.

    • Course Number:
    260283_eng