Round .net DateTime milliseconds, so it can fit the sqlserver milliseconds
- by stacker
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: http://stackoverflow.com/questions/634122/milliseconds-wrong-when-converting-from-xml-to-sql-server-datetime sql server also has an precision issue.