Information technology - Database languages - SQL Technical Reports - Part 2: SQL Support for Time-Related Information
Introduction: The organization of this part of ISO/IEC 19075 is as follows: 1) Clause 1, “Scope”, specifies the scope of this part of ISO/IEC 19075. 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this part of ISO/IEC 19075, constitute provisions of this part of ISO/IEC 19075. 3) Clause 3, “Time-related datatypes, constructs, operators, and predicates”, explains time-related datatypes, operators, and predicates in SQL. 4) Clause 4, “Time-related Tables”, explains how time-related tables are used. vi SQL Support for Time-Related Information ©ISO/IEC 2014 – All rights reserved DTR 19075-2:2014(E)
Scope: This Technical Report describes the support in SQL for time-related information. This Technical Report discusses the following features of the SQL language: Time-related datatypes Operations on time-related data Time-related Predicates Application-time period tables System-versioned tables Bitemporal tables ©ISO/IEC 2014 – All rights reserved Scope 1