O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

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 6. Working with Date and Time Values

This chapter deals with recipes for date, time, and related temporal datatypes. Queries involving dates and times are very common in almost all databases. Working with dates and times is also very strange when compared to other forms of data, due to the long history (pardon the pun) of how our concepts of dates, hours, minutes, seconds, days, months and years came about. For instance, our division of minutes into 60 seconds, hours into sixty minutes, and days into two 12-hour blocks is derived from ancient Sumerian and Babylonian tradition. And they got the notion of a base-12 for counting hours and other things by using the segments of the four fingers (not the thumb) of one hand.

Calendars around the ...

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