A temporally oriented data model
ACM Transactions on Database Systems (TODS)
A guide to the SQL standard (4th ed.): a user's guide to the standard database language SQL
A guide to the SQL standard (4th ed.): a user's guide to the standard database language SQL
An introduction to database systems (7th ed.)
An introduction to database systems (7th ed.)
Extensions to SQL for Historical Databases
IEEE Transactions on Knowledge and Data Engineering
SQL Extension for Interval Data
IEEE Transactions on Knowledge and Data Engineering
| Hi-index | 0.00 |
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.