ADO - Insert does include Milliseconds...


Further to my other post, the problem seems to lie in inserting datetime
values using ADO into a SQL Server 7 database.

When using the INSET statement it works, for example, "10:15:30.738" get's
inserted correctly.  When using a TField/TDateTimeField.Value/AsDateTime
property, it will get inserted as "10:15:31" (rounded up!).

However... reading from the database then using FormatDateTime() with 'zzz'
does extract the milliseconds correctly.

Does anyone know a way of getting around this insert issue?