Is there a reason not to use DateTime2?

Question

Am I missing a reason not to use the new DateTime2 datatype?

For example, might it cause problems when migrating to another database system or integrating it with another technology?

Answer 1

One of the definitive articles is this from Tibor Karaszi

In favour:

• Better precision
• Potentially less storage

But probably best of all judging by frequency of questions here:

• Better support for ANSI date formats (yyyy-mm-dd is not safe otherwise)