title: MySql String To Date Malfunction
body: <p>I've got a MySQL db that of course, stores a DateTime in the form of a string.  I'm trying to convert this to a DateTime so I can filter by year, Month and so on.</p>
  
  <pre><code>SELECT breadCrumbDateTime, STR_TO_DATE(breadCrumbDateTime, '%m/%d/%y %H:%i:%s')
  </code></pre>
  
  <p>And the value of 'breadCrumbDateTime' looks like this.  </p>
  
  <p>'07/15/2017 15:05:16'</p>
  
  <p>However, the STR_TO_DATE function always returns null. </p>
  
  <p><a href="https://i.stack.imgur.com/8xG1x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8xG1x.png" alt="enter image description here"></a></p>
  
  <p>What is the proper format that I should be using to get the STR_TO_DATE function to behave correclty.</p>