2 Replies Latest reply: Jul 22, 2011 7:30 AM by Olaf Joppe RSS

    convert timestamp to string

      Hi

       

      I have 2 columns  datatext(datatype varchar2) and date_created(timestamp)

       

      the sample data for the columns

       

      datatext  - apr-23-2011

       

      date_created - 4/23/2011 1:56:19 PM

       

      Now i want convert date_created format to datatext  ..

       

      How do i do that ?

       

      Please Help...