SQL2008R2: DATETIME2 TO DATETIME CAST ISSUE.

Please refer the following links about millisecond precision in datetime,

http://bytes.com/topic/sql-server/answers/578416-weird-millisecond-part-datetime-data-sql-server-2000-a

http://stackoverflow.com/questions/8153963/sql-server-2008-and-milliseconds

http://improve.dk/getting-bit-by-datetime-rounding-or-why-235959-999-ltgt/

http://milesquaretech.com/Blog/post/2011/09/12/DateTime-vs-DateTime2-SQL-is-Rounding-My-999-Milliseconds!.aspx

---

Regards, Dineshkumar,

Please 'Mark as Answer' if my post answers your question and 'Vote as Helpful' if it helps you