O'Reilly logo

Oracle® SQL by Example, Fourth Edition by Alice Rischert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required