Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TimeStamps calculating differently
Message
De
17/08/2007 12:20:28
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01248245
Message ID:
01248808
Vues:
28
>
>Cetin, you wrote "It is due to how datetime is stored (a silly way IMHO but not VFP's fault)"
>Can you point to some article where datetime storage is described?
>Thank you.

From VFP9 help:
"To store values that are both dates and times or only dates, use the DateTime data type. A DateTime value is stored in eight bytes — two four-byte integers."

Not different from other languages do. Rest is checking the values using an hexeditor. Storing in 8 bytes are not done the same way everywhere AFAIK. There are information about it on many places. For example if you use filer to get file times, last 4 bytes store the time as a fraction of the day (and since fractions are not exact numerics problems start).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform