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

    convert timestamp to string



      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...