Re: Decoding a date & time format

From: Phil Carmody <thefatphil_demunged_at_yahoo.co.uk>
Date: Tue, 28 Oct 2008 15:51:07 +0200
Message-ID: <87abcoesl0.fsf@nonospaz.fatphil.org>


"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
Received on Tue Oct 28 2008 - 08:51:07 CDT

Original text of this message