Re: Decoding a date & time format

"Rob Nicholson" <rob.nicholson_at_nospan.com> writes:
> Not sure if this is a good place to post, but we're trying to reverse
> engineer an Oracle database which has two fields for date & time. They don't
> seem to be encoded using the standard Oracle date/time fields so we suspect
> the developer has used some bespoke encoding system.
>
> So I thought it would be a good challenge for somebody mathematically
> minded.
>
> The example I currently have is:
>
> 17th October 2008 encoded as 131598865

Hexadecimal: 0x07D80A11
And:

 07D8 = 2008
   0A = 10
   11 = 17

> 13:54:49 encoded as 221655296

Hexadecimal: 0x0D363100
And:

 0D = 13
 36 = 54
 31 = 49

Phil

-- 
Christianity has such a contemptible opinion of human nature that it does
not believe a man can tell the truth unless frightened by a belief in God.
No lower opinion of the human race has ever been expressed.
-- Robert Green Ingersoll (1833-1899), American politician and scientist