DateTime from .NET losing more than a millisecond when saved to SQL Server RRS feed

  • Question

  • I have some code that is saving a DateTime (07/29/2011 02:16:25.7245169) to SQL Server 2008 R2 using a strong typed dataset.  Once saved, the date becomes 07/29/2011 02:16:25:7230000.  I get it that SQL Server only supports three places past the decimal.  At that point I would expect it to round up, round down, or truncate.  I am just wondering why it would drop a whole .0015169.  I guess I would expect or, pretty much anything but the that I am getting.  Anyone have any ideas?


    Friday, July 29, 2011 8:21 PM


All replies