Oracle SQL By Example

Chapter 5. Date and Conversion Functions

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 ...