Hi petegajria,

> > QueryField.AsDateTime = Now;
>
> the above sets all the millisec times to 000
> the prob is im running a sync between m$sql & an interbase db
> where the timestamp on the sqlserver side is always assumed to
> be correct
> i tried putting in the value i get from sqlserver as datetime,
> astring, asvariant, assqltimestamp & all of them failed

In what form do you get that value? As a TDateTime with non-zero
milliseconds? And if so: if you assign that value to Field.AsDateTime,
do the milliseconds get cleared?

Greetings,
Paul