Advertisement

Working with Date and Time Values

  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

Abstract

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.

Keywords

Time Zone Full Moon Format Code Format Option Daylight Saving 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Grant Allen, Bob Bryla, and Darl Kuhn 2009

Authors and Affiliations

  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

There are no affiliations available

Personalised recommendations