difference between DateTime and DateTime2 [duplicate]

Question

Possible Duplicate:
SQL Server datetime2 vs datetime

What is the difference between DbType.DateTime and DbType.DateTime2 in .NET?

If I am using DbType.Date and I want to change to a DateTime type should I use DateTime or DateTime2?

Sfumato

Possible duplicate of #1334643 – Charpentier

I have clearly referred to the DbType class found in .NET. I am using an MDB database so it has nothing to do with SQL Server. This question should not be closed! – Sfumato

To those who upvoted my comment: please vote to reopen this question. – Sfumato

Answer 1

DbType.DateTime and DbType.DateTime2 both map to the .NET type System.DateTime. If you need to have additional precision and dates that go back before 1753, then use DateTime2; otherwise DateTime will suffice.

This MSDN link explains it pretty well.

Hope this helps!

Surefooted

Answer 2

DbType.DateTime2 and DbType.DateTime mirror exactly the types found in SQL Server as stated by this post.

When I do SQL Server work, I don't usually need that extra resolution, nor do I go back to 1753, so in .NET I tend to use System.DateTime for this and not either one. If you need to go way back in time or need mad precision, use DbType.DateTime2 paired with a SQL Server type of DateTime2.

So in short, if you're programming using Access, you probably shouldn't be using either one.

Tyche

Why shouldn't I be using either one if I am using Access? – Sfumato