SQL2008R2: DATETIME2 TO DATETIME CAST ISSUE.

Itai,

it is because of the accuracy of datetime. It is only 0.00333 seconds.

You can find more information in the SQL Server Documentation.

So I'm afraid, that there is no way.

---

Have a nice day,

Christoph Muthmann

Microsoft SQL Server MVP - Blog