XPost: comp.database.oracle, sci.math   
   From: thefatphil_demunged@yahoo.co.uk   
      
   "Jon Slaughter"  writes:   
   > "Phil Carmody"  wrote in message   
   > news:87abcoesl0.fsf@nonospaz.fatphil.org...   
   >> "Rob Nicholson"  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   
   >   
   > Which means it's simply byte byte word format.   
   >   
   > i.e., day + month << 8 + year << 16   
      
   Not in C, it's not. + has higher precedence than <<.   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)