title: Trunc date field in mysql like Oracle
body: <p>I am to not able to use the 'trunc(in oracle)' function in 'mysql' database.  I have a table called dlb_cc_purchase and  date field called due_date in my 'mysql' database. The data displaying in the date field like <code>20-11-2014 00:00:00</code> (20-nov-2014). in oracle we are using query</p>
  
  <pre><code>select * from dlbcc_purchase where trunc(due_date) = '20-nov-2014' 
  </code></pre>
  
  <p>Oracle DB will fetch the row with due date 20-11-2014 00:00:00. How can I use this function in 'mysql'?</p>
  
  <p>I know this is a basic question, but i was trying to do this for long time with truncate, str_to_date... but not able to fetch value. Please help.</p>