Share via


2.1.2.172 T011, Timestamp in Information Schema

V0208:

The specification states the following:

 Subclause 6.1, "<data type>": The TIMESTAMP <datetime type> without the <with or without time zone> clause
  
 <datetime type> ::=
 DATE
 ...
 | TIMESTAMP [ <left paren> <timestamp precision> <right paren> ]
 ...

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

Transact-SQL does not support this feature. The Transact-SQL timestamp data type is different from the timestamp data type that is defined in [ISO/IEC9075-2:2011].

For more details, see feature F051-03 (section 2.1.1.27).