How do i convert datetime to date? : I've got this SQL and my table is DATETIME

    $sql = "SELECT * FROM rapport WHERE user_checkin LIKE '".$cYear."-".$cMonth."-%' ";

what I want is convert that to just give me the date so far I've tested

CAST, DATE, DATE_FORMAT. with no success. 