title: mysql convert String to datetime format
body: <p>In MySQL trying to convert string to date time format, but its returning the null value.</p>
  
  <p>What it the correct way to convert below string to datetime format?</p>
  
  <pre><code>&gt; select STR_TO_DATE('8/16/18 7:00 PM', '%c/%e/%Y %r');
  +-------------------------------------------------+
  | STR_TO_DATE('8/16/18 7:00 PM', '%c/%e/%Y %r')   |
  +-------------------------------------------------+
  | NULL                                            |
  +-------------------------------------------------+
  </code></pre>
  
  <p>Thanks</p>