>>>For my own information, does anyone know the format of the storage of a datetime value in a table?
>>>
>>>I've look at this and can't discern how VFP is reading the value. It doesn't seem to be a FILETIME structure, nor a SYSTEMTIME structures.
>>>
>>>Any one know this?
>>
>>Hi George,
>>It stores it as 2 integers. 1st part is Julian day number (sys(1)). 2nd part is milliseconds since midnight.
>
>Cetin,
>
>Thanks for the information. I'll look at that in the morning.
>
>It does seem, however, that this wouldn't be the best way to do this. I realize that VFP datetime have a maximum resolution of one second. If they're two integers (WORDs) they're only 4 bytes. If they're two DWORDS, then they're 8 bytes. And if they're 8 bytes, then why not use a SYSTEMTIME structure? After all, it would make the functions like YEAR(), MONTH(), and DAY() faster.
Sorry I should say 32bit integers. Check my reply to myself that I forgot to CC.
Cetin