title: mysql change date format
body: <p>I have a date field (tinytext) holding date information in format of  "dd-mm-yy" e.g 07-01-90. Using a mysql query I want to change it to yyyy-mm-dd date format. I tried the code below but nothing happens.</p>
  
  <pre><code>mysql_query("UPDATE Table SET date=STR_TO_DATE('date','%Y,%m,%d')");
  </code></pre>