>>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.
George
Ubi caritas et amor, deus ibi est