title: MySQL update datetime field
body: <p>I have the following query that is executing successfully, but it is NOT updating the record. <code>Departure_Date2</code> and <code>Arrival_Date2</code> are datetime fields.  I can't for the life of me figure out why? I've tried with a dash and a forwardslash and still nothing.</p>
  
  <pre><code>UPDATE table SET 
  Departure_Date2 =  '22/Nov/15 17:37',
  Arrival_Date2 =  '22/Nov/15 19:20' 
  WHERE PK =131500
  </code></pre>