Does SQL Server 2005 support datetime2

Question

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

Garett · Accepted Answer · 2012-02-06T01:25:52.660

6

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

edited Feb 06 '12 at 01:25

answered Feb 06 '12 at 01:11

Garett

16,632
5
55
63

It says "SQL Server 2008" in the header of your link? – ahmd0 Feb 06 '12 at 01:13
@ahmd0 I updated the link. It does not support datetime2 based on data types listed. – Garett Feb 06 '12 at 01:14
Yeah, I thought so. Thank you. – ahmd0 Feb 06 '12 at 01:15

score 1 · Answer 2 · answered Dec 15 '13 at 13:55

Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works.

NOTE: You'll have to do this every time you update the model from database.

score 0 · Answer 3 · edited May 23 '17 at 11:53

0

maybe you encounter this problem:

The version of SQL Server in use does not support datatype 'datetime2

you can see the solution as following:

Using SQL Server 2008 and SQL Server 2005 and date time

edited May 23 '17 at 11:53

Community

1
1

answered Nov 26 '12 at 07:02

MichAdel

737
4
3

Does SQL Server 2005 support datetime2

3 Answers3

Linked