Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DateTime data
Message
From
07/02/2002 11:35:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
07/02/2002 11:15:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00616671
Message ID:
00616680
Views:
17
>Does anyone know the method VFP uses to encode the YYYYMMDD HH:MM:SS data into the 8 bytes of a DATETIME field? I haven't figured out DOUBLE yet either.

DateTime: I heard a claim somewhere that there is one byte each for century, year, month, day, hour, minute, second, 100th second. However, there seems to be no way to actually 100th. seconds, so this may not be entirely true.

For Double, you have to search the IEEE standars for floating-point numbers. Briefly, if I remember correctly, there is one bit for the sign, several for the exponent, several for the mantissa (do you know scientific notation?) - all this in binary.

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform