Oracle Database 11g: Managing Time Zones and Datetime Functions

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.