Chapter 13

Working with Temporal Data

Key Skills & Concepts

Images    Create and Use System-Versioned Tables

Images    Create and Use Application-Time Period Tables

Images    Create and Use System-Versioned Application-Time Period Tables


In this chapter, I discuss the temporal features that were added to the SQL:2011 standard. Temporal data is data that changes over time. In SQL, the term temporal data refers to any data that is defined with one or more associated ...

Get SQL: A Beginner's Guide, Fourth Edition, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.