title: Oracle to_date with p.m./a.m
body: <p>I need to convert a string into a Date in oracle.</p>
  
  <p>The format of the string is like this:</p>
  
  <pre><code>'08/11/1999 05:45:00 p.m.'
  </code></pre>
  
  <p>But the last position can change p.m or a.m.
  I tried to do some like:</p>
  
  <pre><code>to_date('08/11/1999 05:45:00 p.m.', 'dd/mm/yyyy hh:mi:ss a.m./p.m.')
  
  to_date('08/11/1999 05:45:00 p.m.', 'dd/mm/yyyy hh:mi:ss am/pm')
  </code></pre>
  
  <p>But return me an error ORA-01855 : AM/A.M. or PM/P.M. required... any idea ?</p>