title: How to insert date(y-m-d) into MySQL database?
body: <p>I have a field of type date in MySQL. When I try to insert any date in this field with PHP using following query, It stores 0000-00-00 in that field.</p>
  
  <p>For example:</p>
  
  <pre><code>UPDATE test SET dob=2000-09-20 WHERE id=3
  </code></pre>