I want to convert the datetime value to the value that I will get from SQL Server 2008.
SQL Server truncate the milliseconds to 3 digits, so I truncate the milliseconds already. But the problem is that as you can see here: Milliseconds wrong when converting from XML to SQL Server datetime. SQL Server also has an precision issue.
See Question&Answers more detail:os