O'Reilly logo

Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Database 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 5Storing and Processing Dates and Times

In this chapter, you will see how to

Image Process and store a specific date and time, collectively known as a datetime. An example of a datetime is 7:15:30 p.m. on October 10, 2007. 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 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 24-hour ...

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