title: ORA-01858 Error Message
body: <p>I have a question regarding date format error. So i have this query</p>
  
  <pre><code>SELECT TO_DATE (PS.PROJECT_START_DT, 'MM/DD/YYYY')
  </code></pre>
  
  <p>and gives me <strong>ORA-01858: a non-numeric character was found where a numeric was expected</strong></p>
  
  <p>my table structure is this</p>
  
  <pre><code>PROJECT_START_DT PROJECT_END_DT JOB_NAME
  2/5/2015         4/2/2015       W-IGG
  2/18/2015        3/19/2015      W14056
  2/5/2015         3/31/2015      W14013
  </code></pre>
  
  <p>Please help me with my issue with date format</p>