title: mysql database date field datatype
body: <p>Hope somebody can advise on the following:</p>
  
  <p>I have created a table into my database which has a coloumn with datatype defined as DATE. The normal MySQL date order is YYYY-MM-DD, however I need to enter it in format DD-MM-YYYY.</p>
  
  <p>I am using php to insert data into my table, and I was wondering at what point should I convert the date format.</p>
  
  <p>To summerize, I am asking the following:</p>
  
  <ol>
  <li>Is it possible to insert into MySQL database where field is formatted as DATE, a date in format DD-MM-YYYY instead in format YYYY-MM-DD?</li>
  <li>If not possible, can I convert a value posted from PHP in format DD-MM-YYYY into the format YYYY-MM-DD using the MySQL syntax or I should use PHP to post the value in YYYY-MM-DD format?</li>
  </ol>
  
  <p>Thank you in advance</p>