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

ISO/IEC 19075-2:2021/Cor 1:2026 is an ISO/IEC technical corrigendum for the use of database language SQL in time-related information. It corrects the description of the TIMEZONE_HOUR field in datetime values, so database vendors, SQL implementers, and documentation teams can use the amended wording consistently.

What does ISO/IEC 19075-2:2021/Cor 1:2026 specify?

ISO/IEC 19075-2:2021/Cor 1:2026 specifies a correction to Part 2 of the ISO/IEC guidance for SQL time-related information. The corrigendum amends clause 4.2, “Datetime types,” by replacing the row for TIMEZONE_HOUR in Table 1, “Fields in datetime values.”

In practical terms, the document tells readers which text to use instead of the earlier wording. That matters when you describe SQL datetime fields, validate time zone-related data, or align product documentation with the corrected terminology.

What are the key requirements of ISO/IEC 19075-2:2021/Cor 1:2026?

The corrigendum is focused on one technical point: the definition of TIMEZONE_HOUR in Table 1. It corrects the meaning of that field so that the hour value of a time zone displacement is described with an implementation-defined negative lower bound and positive upper bound.

• TIMEZONE_HOUR - Clause 4.2 replaces its table row with wording that identifies it as the hour value of a time zone displacement.

  • In practice, this tells implementers and spec writers how to label and interpret the field in SQL datetime values.

• Range wording - The corrected row states that the negative end is implementation-defined but not greater than -12, and the positive end is implementation-defined but not less than +14.

  • In practice, software that handles SQL time zone data should allow for that range when documenting, checking, or mapping the field.

• Table 1, “Fields in datetime values” - The corrigendum changes the table entry rather than rewriting the surrounding clause.

  • In practice, readers should apply the corrected row directly to the existing table structure in the base part.

• Clause 4.2, “Datetime types” - The correction sits inside the part of the document that covers date and time-related SQL types.

  • In practice, this shows that the corrigendum affects terminology and field description for datetime handling, not a broader change to the whole standard.

This corrigendum is short, but it is important for consistency. If you maintain SQL documentation or an implementation guide, it is the corrected table wording that should be quoted and used.

What terms does ISO/IEC 19075-2:2021/Cor 1:2026 define?

• TIMEZONE_HOUR - The hour value of a time zone displacement in a datetime value.
• time zone displacement - The time zone offset whose hour component is identified by TIMEZONE_HOUR.
• datetime values - SQL values that carry date and time-related fields, including timezone-related fields.
• Datetime types - The group of SQL types covered by clause 4.2.
• Table 1 - The table titled “Fields in datetime values,” where the corrected row appears.

Who uses ISO/IEC 19075-2:2021/Cor 1:2026?

ISO/IEC 19075-2:2021/Cor 1:2026 is used by SQL database implementers, database language designers, and documentation teams that describe datetime behavior. It is also useful for quality managers, test engineers, and buyers who need to check whether a product’s SQL time-related terminology matches the corrected ISO/IEC wording.

In practice, these users apply it when they review field names, validate time zone handling, update product specifications, or compare vendor documentation against the corrected table entry.

What changed in ISO/IEC 19075-2:2021/Cor 1:2026 from the previous edition?

ISO/IEC 19075-2:2021/Cor 1:2026 is Technical Corrigendum 1 to ISO/IEC 19075-2:2021. It replaces the TIMEZONE_HOUR row in Table 1 with corrected wording for the hour value of a time zone displacement and its allowed range expression.

What does the ISO/IEC 19075-2:2021/Cor 1:2026 document contain?

The document contains the corrigendum front matter, the correction notice, clause 4, and subclause 4.2 with Table 1, “Fields in datetime values.” Its main content is the replacement text for one table row, so readers can update SQL-related descriptions without reworking the rest of the guidance.

For implementers, this means the document is mainly a reference for terminology and wording. For documentation and testing teams, it is the authoritative text to use when checking how TIMEZONE_HOUR is described in datetime-related SQL material.

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]
...