title: mySQL how to change date format
body: <p>the date format in mySQL have type (yyyy-mm-dd), now I try to reverse it (dd-mm-yyyy).
  I got table user</p>
  
  <pre><code>CREATE TABLE USER 
  (
    USER_ID INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
    DOB DATE,   
  );
  </code></pre>
  
  <p>so when i insert value into that:</p>
  
  <pre><code>INSERT INTO USER(DOB) VALUES(DATE_FORMAT('13-07-1990','%d,%m,%Y));
  </code></pre>
  
  <p>however, it does not work. It notice that I should use 1990-07-13 instead of '13-07-1990'. 
  please help me to do that. Thanks.</p>