Oracle Database 10g SQL

CHAPTER 4Storing and Processing Dates and Times

In this chapter, you will

Process and store a specific date and time, collectively known as a datetime. An example of a datetime is 7:15:30 PM on October 10, 2005. You store a datetime using the DATE type. The DATE type stores the century, all four digits of a year, the month, the day, the hour (in 24-hour format), the minute, and the second.

Use timestamps, which allow you to store a specific date and time. A timestamp stores the century, all four digits of a year, the month, the day, the hour (in ...