Oracle SQL By Example

Chapter 5. Date and Conversion Functions

Chapter Objectives

In this chapter, you will learn about:

• Applying Oracle’s Date Format Models

• Performing Date and Time Math

• Understanding Timestamp and Time Zones Data Types

• Performing Calculations with the Interval Data Types

• Converting from One Data Type to Another

In this chapter, you will gain an understanding of Oracle’s two date-related categories of data types: the datetime data types and the interval data types.

The datetime data types keep track of both date and time; they consist of the individual data types DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. In the first two labs, you will learn about the most popular data type—the DATE data type. Lab ...