title: MySQL str_to_date()
body: <p>I am running into an issue trying to format a date column from looking like this:  <code>05-JUN-15</code> to the standard MYSQL format. What I tried to do was:</p>
  
  <pre><code>UPDATE sp_building_headcount
      set `ATTENDANCE_LOCALDATE` = str_to_date(`ATTENDANCE_LOCALDATE`,'%d-%b-%y')
  </code></pre>
  
  <p>I thought I selected the right date format but I am getting this error: <code>Incorrect datetime value: '05-JUN-15' for function str_to_date</code></p>
  
  <p>What would be the correct date/time format? </p>