title: Mysql STR_TO_DATE incorrect datetime value
body: <p>I've loaded some date from file to table and now i want to convert the string with date to a datetime format. 
  The string i 'datestring' column looks like this '12-16-2010 01:48:28', and if i run this query:</p>
  
  <pre><code>select STR_TO_DATE('12-16-2010 01:48:28', '%c-%e-%Y %T')
  </code></pre>
  
  <p>It returns proper datetime: <code>2010-12-16 01:48:28</code></p>
  
  <p>But when i try to run this:</p>
  
  <pre><code>update database.`temptable` 
  SET datetimefile = (SELECT STR_TO_DATE(datestring, '%c-%e-%Y %T'))
  </code></pre>
  
  <p>I get those kind of errors:</p>
  
  <pre><code>Incorrect datetime value: ''12-16-2010 01:48:28'' for function str_to_date
  </code></pre>
  
  <p>Any ideas?</p>