sql-serversql-server-2005sqldatatypesdatetime2

Does SQL Server 2005 support datetime2

I can't find in the official documentation if SQL Server 2005 supports the datetime2 data type.

Solution

  • Apparently it does not. Here are the supported data types.

    EDIT:

    According to the following sources datetime2 was introduced in SQL Server 2008.

    http://blogs.msdn.com/b/manisblog/archive/2007/08/28/sql-server-2008-enhancements-in-date-and-time-data-types.aspx

    https://web.archive.org/web/20211020150018/https://www.4guysfromrolla.com/articles/101508-1.aspx