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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have