title: mysql date format dd/mm/yyyy?
body: <p>Does anyone know how to insert into column(of date type) date in the format of dd-mm-yyyy?</p>
  
  <p>I'm using calendar, and it selects days like dd-mm-yyyy, but it can't be inserted because of the format that uses mysql by default (yyyy-mm-dd).</p>
  
  <p>The problem is, that I need to compare dates that has been inserted by the calendar and the dates that has been automatically inserted with current_date function. Basicly I have column DoR (date_of_registration) and Status. I've made DoR of date type, and Status of varchar(). In the Status I use Calendar to insert the date. Thus, I've compared it anyway but it gives strange results. I guess it is not comparing correctly.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks</p>