SQL Server 2005 是否支持 datetime2 [英] Does SQL Server 2005 support datetime2

问题描述

官方文档中好像没有找到SQL Server 2005是否支持datetime2数据类型?

解决方案

显然没有.以下是支持的数据类型.>

根据以下来源，datetime2 是在 SQL Server 2008 中引入的.

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

http://www.4guysfromrolla.com/articles/101508-1.aspx

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

解决方案

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

http://www.4guysfromrolla.com/articles/101508-1.aspx

这篇关于SQL Server 2005 是否支持 datetime2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！