Decoding a date & time format
Date: Tue, 28 Oct 2008 12:00:57 -0000
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