>I am skeptical of Erik's explanation that the table values contain milliseconds. I wrote this test program:
>
AS you should have been. The explanation I posted was gleaned from reading other's solution to this problem, and until this afternoon, I had never tested it myself. I performed some similar tests to yours, and came up with the same conclusion: datetime fields store what they display. Sorry for temporarily misleading you.
Erik Moore
Clientelligence