Hi Hans,


You must convert SQL datetime to string with ms:
CONVERT(char, datetime_field, 21)

MartinJ

>Hey all,
>
>I've got an sql table containing a datetime field yyyy-mm-dd hh:mi:ss.mmm. When I do a query form VFP I get the datetime in format yyyy-mm-dd hh:mi:ss but now I realy need to get the milliseconds too. Is there a way ??
>
>Greetz,
>Hans