Oracle Database 12c SQL

CHAPTER

5

Storing and Processing Dates and Times

In this chapter, you’ll learn how to perform the following tasks:

   Use a datetime to store a date and time. A datetime stores a year, month, day, hour, minute, and second.

   Use a timestamp to store a date and time. A timestamp stores a year, month, day, hour, minute, second, fractional second, and time zone.

   Use a time interval to store a length of time. An example time interval is 1 year 3 ...