title: how to insert date in MySQL
body: <p>i am developing window application using visual studio and c#
  i want to insert date in Mysql database table which having datatype date</p>
  
  <p>using datetimepicker control of visual studio</p>
  
  <p>i wrote an insert query like this (<code>insert into table name values('"+ datetimepicker.value + "'</code>)</p>
  
  <p>it give me following error</p>
  
  <pre><code>ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.47-community]Incorrect datetime value: '01-06-2010 00:00:00' for column 'Date' at row 1
  </code></pre>
  
  <p>can any one resolve this problem </p>