home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 488 of 2,288   
   Jim Kennedy to Mau Pastor   
   Re: [WEIRD] Merge date and char   
   04 Oct 03 15:41:20   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca