title: MySQL Convert STR_TO_DATE with 10 digit microsecond
body: <p>I want to convert this string to <code>datetime</code> format
  <code>09-OCT-17 03.08.25.907000000 PM</code></p>
  
  <p>Unfortunately, this microsecond part is giving a problem for me. It has 9 precision. (edited) </p>
  
  <pre><code>select STR_TO_DATE('09-OCT-17 03.08.25 PM', '%d-%b-%y %h.%i.%s %p') as DATE
  </code></pre>
  
  <p>It worked without the microsecond part</p>