Abstract

Time intervals used in conjunction with the Timestamp data type as implemented in the SQL-92 standard provide a useful technique for referencing periods of time. One of the important differences between scalar data types and the interval data type is that the interval data type has a much wider set of comparison operations, which are central to the INNER JOIN operation. An example is presented to demonstrate the care that must be exercised in constructing INNER JOINs that involve interval-valued attributes, and examples are presented to demonstrate how to do INNER JOINs correctly.

Full Text
Paper version not known

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call