From: kennedy-downwithspammersfamily@attbi.net   
      
    wrote in message   
   news:1109731580.120769.164910@g14g2000cwa.googlegroups.com...   
   > sorry about bothering you, but when i do something like   
   >   
   > select to_date(to_char(date_column, 'yyyy-mm-dd hh24:mi:ss'),   
   > 'yyyy-mm-dd hh24:mi:ss') from table_name   
   >   
   > in my pro*c code, i get back   
   >   
   > 2005-02-24 00:00:00   
   >   
   > when  data is 2005-02-24 11:05:07   
      
   get rid of the to_date.  Doesn't ProC have a native date interface?   
   Wouldn't it make more sence to use that?   
   Jim   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)