title: oracle - to_Date format
body: <p>What format would you use to convert this CHAR value into a date?</p>
  
  <pre><code>Apr  9 1996  2:11:00:000PM
  
  
  ie. select to_date('Apr  9 1996  2:11:00:000PM','???') from dual;
  </code></pre>
  
  <p>Has anyone found a good reference because all the ones I see expect that the hour has a preceding 0 to start with.</p>