O'Reilly logo

Oracle Database 10g SQL by Jason Price

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 4Storing and Processing Dates and Times

In this chapter, you will

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

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

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