XPost: comp.database.oracle, sci.math   
   From: thefatphil_demunged@yahoo.co.uk   
      
   "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   
      
      
   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)