Subject Re: Internal Date Format
Author Aage Johansen
On Thu, 3 Jul 2003 20:02:33 +0000 (UTC), bmorrison_navco wrote:

> Greetings All,
> I have the envious task of trying to extract data from 56 gigs of
> corrupted gdb.
> My question regards date fields, and how date information is stored
> internally.
> 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.).
> Any input on this would be greatly appreciated!

Which version of Interbase/Firebird?
With versions pre-6 (and later with SQLdialect=1) the DATE field is
date&time. <date> is number of days since 'some date' (sometime in
November 18-hundred-and-something?, or 30.12.1899?). <time> is fraction of
24 hours.
Did you try the IBsurgeon-tool? Take a look at
IBPhoenix can also help with corrupted databases. But, maybe you want to
keep all the fun for yourself ...

Aage J.