title: Convert varchar2 to Date ('MM/DD/YYYY') in PL/SQL
body: <p>I need to convert string from varchar to Date in 'MM/DD/YYYY' format. My input string is '4/9/2013' and my expected output is '04/09/2013'. i.e. 2 digit month, 2 digit date and 4 digit year seperated by'/'</p>
  
  <p>I have below data:
  DOJ varchar2(10 Byte)column has '4/9/2013' value.
  I am using 'select TO_DATE(DOJ,'MM/DD/YYYY') from EmpTable. But I am getting result as 09-APR-13. I want it in 04/09/2013 format.</p>
  
  <p>Please advise. Thanks in advance.</p>