SQL:2011 or ISO/IEC 9075:2011 (under the general title "Information technology - Database languages - SQL") is the seventh revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in December 2011. The standard consists of 9 parts which are described in detail in SQL.
IMMEDIATELY PRECEDES, and
IMMEDIATELY SUCCEEDS(which are modified versions of Allen's interval relations)
PERIOD FOR SYSTEM_TIMEannotation and
WITH SYSTEM VERSIONINGmodifier. System time periods are maintained automatically. Constraints for system-versioned tables are not required to be temporal and are only enforced on current rows
AS OF SYSTEM TIMEand
VERSIONS BETWEEN SYSTEM TIME ... AND ...clauses
IBM DB2 version 10 claims to be the first database to have a conforming implementation of this feature in what they call "Time Travel Queries", although they use the alternative syntax
FOR SYSTEM_TIME AS OF.
Oracle Oracle 12c supports temporal functionality in compliance with SQL:2011. Versions 10g and 11g implement the time-sliced queries in what they call Flashback Queries, using the alternative syntax
AS OF TIMESTAMP. Notably both of Oracle's implementations depend on the database transaction log and so only allow temporal queries against recent changes which are still being retained for backup.
Manage research, learning and skills at NCR Works. Create an account using LinkedIn to manage and organize your omni-channel knowledge. NCR Works is like a shopping cart for information -- helping you to save, discuss and share.