From: kennedy-down_with_spammers@no_spam.comcast.net   
      
   theDate+(hh24/24)+(mi/(24*60))   
   Should do it.   
   Jim   
      
   --   
   Replace part of the email address: kennedy-down_with_spammers@attbi.com   
   with family.  Remove the negative part, keep the minus sign.  You can figure   
   it out.   
   "Mau Pastor"  wrote in message   
   news:6575a8ed.0310040028.5e1d9523@posting.google.com...   
   > I am creating a view on a table that has the date information split in   
   > two columns: a DATE column and a char column. The char column holds   
   > the HH24:MI information. Please don't ask me why this is like this,   
   > it's a very old database converted from a different DBMS.   
   >   
   > I need to get this information into a single DATE column. Ny best shot   
   > so far was to try get the total number of minutes with substr and add   
   > them to the date, but I could not get it right.   
   >   
   > Can anyone show me an example?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)