Hi Dave,
I just thought it did then, I guess. I've heard there were problems in a SQL SELECT on a datetime value. Kind of like adding a decimal value instead of an integer to a date:
d1 = DATE()
d2 = d1 + .05
? d1, d2
? d1=d2
The date values will strip off any of the excess when written to a field. Drove me nuts in a scheduler I did years ago when two date variables wouldn't compare!
>Fred,
>
>I don't think the VFP datetime() function will return millisecond level information. C/C++ functions can, SQL server can.
>
>>Sounds reasonable to me. But I thought that DATETIME() did return a millisecond value, you just didn't see it, and that's what would cause problems in trying to do a SELECT for a specific datetime type value.