Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A Datetime problem
Message
From
23/12/1999 09:48:51
Paul Frost
Instem Computer Systems Ltd
Stone, United Kingdom
 
 
To
19/12/1999 09:32:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00305771
Message ID:
00307887
Views:
47
>Unlike dates, datetime is stored as a double. I hit this sometime ago too and discussed here. If hour portion is not a multiple of 3 then roundation problems occur.

From my understanding, it's not strictly a double, it's actually 2 integers. DateTime is stored in 8 bytes, the first 4 bytes are in integer date, offset from 1/1/100, the remaining 4 bytes are the time in milliseconds since midnight (If I'm wrong, I know I'll be shot down in flames, regardless of how close to Christmas & the season of goodwill, I'm quoting from VfP 5 help here, which has exactly the same problem).

If this is the case, then any difference cannot really be explained as rounding error. And even if rounding error, why a difference of multiples of exactly 3 hours (180000 mS) should have no rounding error.

Paul
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform