I have a weird issue here which I cannot resolve.
I receive a date value which is something like 2010-09-18T12:57:56.341-04:00. As you can see, we have 341 milliseconds. This is presently in a data row. So, if I do this, I can easily see that I have 341 milliseconds:
Dim ldDate As Date = Nothing
ldDate = loRow("LastUpdate")
MessageBox.Show(ldDate.Millisecond.ToString)
If I update my record with loRow("LastUpdate"), SQL Server shows that I have this value: 2010-09-18 12:57:56.340.
So, I lost one millisecond.
Is there some kind of rounding in there?