ISO/IEC 19075-2:2021/Cor 1:2026

• Status: Published
• Publication Date: 30-Jun-2026
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32/WG 3 - Database language
• Current Stage: 6060 - International Standard published
• Start Date: 01-Jul-2026
• Completion Date: 30-Jun-2026

• Corrects: ISO/IEC 19075-2:2021 - Information technology — Guidance for the use of database language SQL — Part 2: Time-related information
• Effective Date: 07-Jan-2026

Overview

ISO/IEC 19075-2:2021/Cor 1:2026 is a technical corrigendum published by the International Organization for Standardization (ISO) for Part 2 of the ISO/IEC 19075 series. This part focuses on guidance for the use of the database language SQL, specifically addressing time-related information in database systems. The corrigendum clarifies and corrects the original 2021 guidance to ensure enhanced accuracy in managing and interpreting time-related data, such as timestamps and time zone details, in SQL-based applications.

Key Topics

• Time-Related Data in SQL
  The standard provides authoritative guidance on handling time-related datatypes in SQL, ensuring consistency and interoperability across different systems.

• TIMEZONE_HOUR Field Correction
  The corrigendum specifically replaces and clarifies the definition of the TIMEZONE_HOUR field within datetime values.

  • The TIMEZONE_HOUR is now defined as the hour value of time zone displacement, which ranges from an implementation-defined negative number not greater than -12 to an implementation-defined positive number not less than +14.

• Accuracy and Interoperability
  By correcting technical details related to datetime fields, the corrigendum supports greater accuracy in data exchange, reporting, and compliance in systems that rely on SQL.

• Implementation Clarity
  The update enables developers, database administrators, and system integrators to understand and leverage the correct specifications when dealing with time zones in SQL databases.

Applications

• Global Database Solutions
  The guidance is essential for organizations that deploy SQL databases across multiple time zones, including international enterprises, cloud service providers, and financial institutions.

• Data Integration and Exchange
  Improved definitions and handling of time zone information help with seamless data integration between applications, minimizing errors that might arise from time zone inconsistencies.

• Regulatory Compliance
  Accurate time-related data management is critical for sectors bound by regulatory requirements, such as finance, healthcare, and telecommunications, where timestamp integrity and traceability are essential.

• Software Development and Maintenance
  The corrigendum provides a clear reference for software developers and maintainers who need to ensure that their SQL implementations correctly interpret and store time zone data, further supporting robust system design.

Related Standards

• ISO/IEC 19075 Series
  This standard is part of the larger ISO/IEC 19075 family, which provides comprehensive guidance on various aspects of the SQL database language.

• ISO/IEC JTC 1/SC 32
  Oversees the development of international standards for data management and interchange, including the SQL family of standards.

• ISO/IEC 9075 (SQL Standard)
  The foundational standard for SQL, defining core language features and requirements for database systems.

• International Standardization for Time Zone Handling
  The guidance in ISO/IEC 19075-2:2021/Cor 1:2026 is aligned with industry best practices for handling global time zones in digital systems.

This technical corrigendum is vital for organizations aiming to maintain up-to-date, standards-based database solutions using SQL, with special attention to the precise management of time-related data and interoperability between diverse systems.

International
Standard
ISO/IEC 19075-2
First edition
Information technology — Guidance
2021-08
for the use of database language
SQL —
TECHNICAL
CORRIGENDUM 1
Part 2:
2026-06
Time-related information
TECHNICAL CORRIGENDUM 1
Technologies de l'information — Recommandations pour
l'utilisation du langage de base de données SQL —
Partie 2: Informations d'horodatage
RECTIFICATIF TECHNIQUE 1
Reference number
ISO/IEC 19075-2:2021/Cor. 1:2026(en) © ISO/IEC 2026

ISO/IEC 19075-2:2021/Cor. 1:2026(en)
© ISO/IEC 2026
All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may
be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on
the internet or an intranet, without prior written permission. Permission can be requested from either ISO at the address below
or ISO’s member body in the country of the requester.
ISO copyright office
CP 401 • Ch. de Blandonnet 8
CH-1214 Vernier, Geneva
Phone: [phone]
...