Information technology — Guidance for the use of database language SQL — Part 2: Time-related information
Introduction: The organization of this document is as follows: 1) Clause 1, “Scope”, specifies the scope of this document. 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this document, constitute provisions of this document. 3) Clause 3, “Terms and definitions”, defines the terms and definitions used in this document. 4) Clause 4, “Time-related data types, constructs, operators, and predicates”, explains time-related data types, operators, and predicates in SQL. 5) Clause 5, “Time-related tables”, explains how time-related tables are used. © ISO/IEC 2021 – All rights reserved ISO/IEC 19075-2:2021(E)
Scope: This document describes the support in SQL for time-related information. This document discusses the following features of the SQL language: Time-related data types Operations on time-related data Time-related Predicates Application-time period tables System-versioned tables Bi-temporal tables © ISO/IEC 2021 – All rights reserved