Share via


2.1.2.238 T502, Period predicates

V0274:

The specification states the following:

 Subclause 8.20, "<period predicate>":
  
 <period predicate> ::=
 <period overlaps predicate>
 | <period equals predicate>
 | <period contains predicate>
 | <period precedes predicate>
 | <period succeeds predicate>
 | <period immediately precedes predicate>
 | <period immediately succeeds predicate>
  
 ...
  
 Conformance Rules:
  
 Without Feature T502, "Period predicates", conforming SQL language shall not contain a <period predicate>.

Microsoft SQL Server 2008 R2 varies as follows:

This feature is absent from the [ISO/IEC9075-2:2008] standard.

Microsoft SQL Server 2012 varies as follows:

Transact-SQL does not support this feature.