>We are converting a FoxPro 2.6 application that used FPSQL.FLL to retrieve info. from SQL-Server tables into Visual FoxPro 5.0.
>
>FPSQL retrieved DateTime fields with a precision of 1/1000th. of a second. We don't seem to be able to get more than a second in precision with VFP 5.0. Is there any way to get better?
>
>Thanks.
>
>Jacques Mainguy.

Since the time is stored on 4 bytes in a datetime field, the precision is about 0.00002 seconds (better than 1/1000th). The problem is that there's no built-in FoxPro function to extract the time from a datetime field.

So, you probably need to write one of your own.

Vlad