ISO/IEC 19075-2:2021Published

Information technology — Guidance for the use of database language SQL — Part 2: Time-related information

Technologies de l'information — Recommandations pour l'utilisation du langage de base de données SQL — Partie 2: Informations d'horodatage

Abstract / 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

Life cycle

Amendments & corrigenda

ISO/IEC 19075-2:2021/Cor 1:2026PublishedInformation technology — Guidance for the use of database language SQL — Part 2: Time-related information — Technical Corrigendum 1International Standard · Published 1 Jul 2026 · ISO/IEC JTC 1/SC 32

Replaces

ISO/IEC TR 19075-2:2015WithdrawnInformation technology — Database languages — SQL Technical Reports — Part 2: SQL Support for Time-Related InformationTechnical Report · Published 17 Jun 2015 · ISO/IEC JTC 1/SC 32