🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 19075-2:2021

BS ISO/IEC 19075-2:2021

$189.07

Information technology. Guidance for the use of database language SQL – Time-related information

Published By Publication Date Number of Pages
BSI 2021 46
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

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

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
7 Tables
8 Foreword
10 Introduction
11 1 Scope
12 2 Normative references
13 3 Terms and definitions
14 4 Time-related data types, constructs, operators, and predicates
4.1 Context of time-related specifications
4.2 Datetime types
16 4.3 DateTime literals
17 4.4 Interval types
18 4.5 Interval literals
19 4.6 Periods
20 4.7 Operations involving datetimes and intervals
4.8 Time-related predicates
4.8.1 Overlaps predicate
21 4.8.2 Period predicates
24 5 Time-related tables
5.1 Introduction to time-related tables
5.2 Application-time period tables
5.2.1 Introduction to application-time period tables
5.2.2 Extensions to primary key / unique constraints
25 5.2.3 Extensions to referential constraints
28 5.2.4 Inserting rows into tables containing an application-time period definition
5.2.5 Updating rows of tables containing an application-time period definition
29 5.2.6 Updating the table between specific points in time
32 5.2.7 Deleting rows from tables containing an application-time period definition
5.2.8 Deleting rows between specific points in time
34 5.2.9 Querying tables containing a period definition
35 5.2.10 Adding a period definition to a table
36 5.3 System-versioned tables
5.3.1 Introduction to system-versioned tables
37 5.3.2 Primary key and referential constraints
38 5.3.3 Updating rows in system-versioned tables
39 5.3.4 Deleting rows in system-versioned tables
5.3.5 Querying system-versioned tables
40 5.4 Bi-temporal tables

Related products

BS ISO/IEC 19075-2:2021
$189.07