2.1.1.26 F051, Basic date and time

  • Article

V0026:

The specification states the following:

 Subclause 6.1, "<data type>": <datetime type> including datetime literals, datetime comparisons, and datetime conversions
  
 <datetime type> ::=
 DATE
 | TIME [ <left paren> <time precision> <right paren> ] [ <with or without time zone> ]
 | TIMESTAMP [ <left paren> <timestamp precision> <right paren> ]
 [ <with or without time zone> ]
  
 <with or without time zone> ::=
 WITH TIME ZONE
 | WITHOUT TIME ZONE
  
 <time precision> ::=
 <time fractional seconds precision>
  
 <timestamp precision> ::=
 <time fractional seconds precision>
  
 <time fractional seconds precision> ::=
 <unsigned integer>
  
 <interval type> ::=
 INTERVAL <interval qualifier>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature.