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_at_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.
Date: Tue, 28 Oct 2008 12:00:57 -0000
Message-ID: <J4idnRzFrs1mY5vUnZ2dnUVZ8tHinZ2d_at_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 - 13:00:57 CET