{"id":381469,"date":"2024-10-20T03:11:39","date_gmt":"2024-10-20T03:11:39","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bs-iso-iec-19075-22021\/"},"modified":"2024-10-26T05:47:55","modified_gmt":"2024-10-26T05:47:55","slug":"bs-iso-iec-19075-22021","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bs-iso-iec-19075-22021\/","title":{"rendered":"BS ISO\/IEC 19075-2:2021"},"content":{"rendered":"<p>This document describes the support in SQL for time-related information.<\/p>\n<p>This document discusses the following features of the SQL language:<\/p>\n<ul>\n<li>\n<p>Time-related data types<\/p>\n<\/li>\n<li>\n<p>Operations on time-related data<\/p>\n<\/li>\n<li>\n<p>Time-related Predicates<\/p>\n<\/li>\n<li>\n<p>Application-time period tables<\/p>\n<\/li>\n<li>\n<p>System-versioned tables<\/p>\n<\/li>\n<li>\n<p>Bi-temporal tables<\/p>\n<\/li>\n<\/ul>\n<h4>PDF Catalog<\/h4>\n<table border=\"1px\" class=\"des-table\">\n<tr>\n<th>PDF Pages<\/th>\n<th>PDF Title<\/th>\n<\/tr>\n<tr>\n<td><b>2<b><\/td>\n<td>undefined  <\/td>\n<\/tr>\n<tr>\n<td><b>5<b><\/td>\n<td>Contents  <\/td>\n<\/tr>\n<tr>\n<td><b>7<b><\/td>\n<td>Tables  <\/td>\n<\/tr>\n<tr>\n<td><b>8<b><\/td>\n<td>Foreword  <\/td>\n<\/tr>\n<tr>\n<td><b>10<b><\/td>\n<td>Introduction  <\/td>\n<\/tr>\n<tr>\n<td><b>11<b><\/td>\n<td>1 Scope  <\/td>\n<\/tr>\n<tr>\n<td><b>12<b><\/td>\n<td>2 Normative references  <\/td>\n<\/tr>\n<tr>\n<td><b>13<b><\/td>\n<td>3 Terms and definitions  <\/td>\n<\/tr>\n<tr>\n<td><b>14<b><\/td>\n<td>4 Time-related data types, constructs, operators, and predicates <br \/> 4.1 Context of time-related specifications <br \/> 4.2 Datetime types  <\/td>\n<\/tr>\n<tr>\n<td><b>16<b><\/td>\n<td>4.3 DateTime literals  <\/td>\n<\/tr>\n<tr>\n<td><b>17<b><\/td>\n<td>4.4 Interval types  <\/td>\n<\/tr>\n<tr>\n<td><b>18<b><\/td>\n<td>4.5 Interval literals  <\/td>\n<\/tr>\n<tr>\n<td><b>19<b><\/td>\n<td>4.6 Periods  <\/td>\n<\/tr>\n<tr>\n<td><b>20<b><\/td>\n<td>4.7 Operations involving datetimes and intervals <br \/> 4.8 Time-related predicates <br \/> 4.8.1 Overlaps predicate  <\/td>\n<\/tr>\n<tr>\n<td><b>21<b><\/td>\n<td>4.8.2 Period predicates  <\/td>\n<\/tr>\n<tr>\n<td><b>24<b><\/td>\n<td>5 Time-related tables <br \/> 5.1 Introduction to time-related tables <br \/> 5.2 Application-time period tables <br \/> 5.2.1 Introduction to application-time period tables <br \/> 5.2.2 Extensions to primary key \/ unique constraints  <\/td>\n<\/tr>\n<tr>\n<td><b>25<b><\/td>\n<td>5.2.3 Extensions to referential constraints  <\/td>\n<\/tr>\n<tr>\n<td><b>28<b><\/td>\n<td>5.2.4 Inserting rows into tables containing an application-time period definition <br \/> 5.2.5 Updating rows of tables containing an application-time period definition  <\/td>\n<\/tr>\n<tr>\n<td><b>29<b><\/td>\n<td>5.2.6 Updating the table between specific points in time  <\/td>\n<\/tr>\n<tr>\n<td><b>32<b><\/td>\n<td>5.2.7 Deleting rows from tables containing an application-time period definition <br \/> 5.2.8 Deleting rows between specific points in time  <\/td>\n<\/tr>\n<tr>\n<td><b>34<b><\/td>\n<td>5.2.9 Querying tables containing a period definition  <\/td>\n<\/tr>\n<tr>\n<td><b>35<b><\/td>\n<td>5.2.10 Adding a period definition to a table  <\/td>\n<\/tr>\n<tr>\n<td><b>36<b><\/td>\n<td>5.3 System-versioned tables <br \/> 5.3.1 Introduction to system-versioned tables  <\/td>\n<\/tr>\n<tr>\n<td><b>37<b><\/td>\n<td>5.3.2 Primary key and referential constraints  <\/td>\n<\/tr>\n<tr>\n<td><b>38<b><\/td>\n<td>5.3.3 Updating rows in system-versioned tables  <\/td>\n<\/tr>\n<tr>\n<td><b>39<b><\/td>\n<td>5.3.4 Deleting rows in system-versioned tables <br \/> 5.3.5 Querying system-versioned tables  <\/td>\n<\/tr>\n<tr>\n<td><b>40<b><\/td>\n<td>5.4 Bi-temporal tables  <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p><b>Information technology. Guidance for the use of database language SQL &#8211; Time-related information<\/b><\/p>\n<table class=\"shortdes-table\" style=\"width: 100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>Published By<\/td>\n<td>Publication Date<\/td>\n<td>Number of Pages<\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/pdfstandards.shop\/product-category\/publishers\/bsi\/\"><b>BSI<\/b><\/a><\/td>\n<td>2021<\/td>\n<td>46<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":381475,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-381469","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-bsi","8":"first","9":"instock","10":"sold-individually","11":"shipping-taxable","12":"purchasable","13":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/381469","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/381475"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=381469"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=381469"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=381469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}