Subject Re: [firebird-support] Internal Date Format
Author Ann Harrison
Bill,

>I have the envious task of trying to extract data from 56 gigs of
>corrupted gdb.
>
Ouch. What happened to the database? Do you understand the way
compression works on data?

>I believe I've found the 8 bytes that determine what the date/time
>is, but have no idea what the values represent (ms from a particular
>datetime/etc.).
>
>
The first longword is the number of days since 17 November 1858.
(That's a long story). The second word is the number of clunks since
midnight of that day. A clunk is the smallest fraction of a day that
allows a whole day to be represented by a longword. 10's of
microseconds, I think, though I'm not sure.

Regards,


Ann