MySQL update datetime field

Question

I have the following query that is executing successfully, but it is NOT updating the record. Departure_Date2 and Arrival_Date2 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.

UPDATE table SET 
Departure_Date2 =  '22/Nov/15 17:37',
Arrival_Date2 =  '22/Nov/15 19:20' 
WHERE PK =131500

Answer 1

A datetime data type has the following format: YYYY-MM-DD HH:MM:SS

For example, 3:30 in the afternoon on December 30th, 1973 would be stored as 1973-12-30 15:30:00.