Chapter 4. Date and Conversion Functions

In this chapter you will gain an understanding of Oracle's two date-related categories of datatypes: the datetime datatypes and the interval datatypes.

The datetime datatypes keep track of both date and time; they consist of the individual datatypes DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. In the first two labs you will learn about the most popular datatype—the DATE datatype. Lab 4.3 introduces you to the other three ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.