wheresql += " and DATE_FORMAT(business_checkindate, '%Y-%m-%d %H:%i:%s') <= DATE_FORMAT('"+str2+"', '%Y-%m-%d %H:%i:%s') ";