title: How do I convert datetime to date?
body: <p>I've got this SQL and my table is <code>DATETIME</code></p>
  
  <pre><code>$sql = "SELECT * FROM rapport WHERE user_checkin LIKE '".$cYear."-".$cMonth."-%' ";
  </code></pre>
  
  <p>What I want is convert that to just give me the date so far I've tested</p>
  
  <p><code>CAST</code>, <code>DATE</code>, <code>DATE_FORMAT</code>. with no success. </p>