Decoding a date & time format

From: Rob Nicholson <rob.nicholson_at_nospan.com>
Date: Tue, 28 Oct 2008 12:00:57 -0000
Message-ID: <J4idnRzFrs1mY5vUnZ2dnUVZ8tHinZ2d@bt.com>


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
13:54:49 encoded as 221655296

I'll try and get some more examples.

Any help appreciated.

Thanks, Rob. Received on Tue Oct 28 2008 - 07:00:57 CDT

Original text of this message