Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with DATETIME field in index
Message
From
10/01/2000 21:05:59
 
 
To
10/01/2000 20:12:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00315277
Message ID:
00315903
Views:
34
>>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, did you see my second post? (I forgot to copy you on that one.) What do you think about those strange hex values for date-time fields?
>
>01/10/2000 13:32:22 or 62 68 25 00 6F BE E7 02 in hex
>01/10/2000 13:32:23 or 62 68 25 00 57 C2 E7 02 in hex
>


They certainly look like they are leaving room for a lot more precision. Hmmmm.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform