Oracle Database 11g: Managing Time Zones and Datetime Functions

Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisite
Familiarity with data processing concepts and techniques

Expected Duration
80 minutes

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.

Objective

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.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.