<t>The MSDN documentation for datetime recommends using datetime2. Here is their recommendation:<br/>
<br/>
<br/>
Use the time, date, datetime2 and<br/>
datetimeoffset data types for new<br/>
work. These types align with the SQL<br/>
Standard. They are more portable.<br/>
time, datetime2 and datetimeoffset<br/>
provide more seconds precision.<br/>
datetimeoffset provides time zone<br/>
support for globally deployed<br/>
applications.<br/>
<br/>
datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified precision it may use less storage.</t>
