Information technology - Guidance for the use of database language SQL - Part 2: Time-related information
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
Project need:
Note: The information provided above was obtained by the Standards Council of Canada (SCC) and is provided as part of a centralized, transparent notification system for new standards development. The system allows SCC-accredited Standards Development Organizations (SDOs), and members of the public, to be informed of new work in Canadian standards development, and allows SCC-accredited SDOs to identify and resolve potential duplication of standards and effort.
Individual SDOs are responsible for the content and accuracy of the information presented here. The text is presented in the language in which it was provided to SCC.