$a = date('Y-m-d',time()).'12:00';$b = date('Y-m-d',time()+24*60*60).'12:00';$sql.=" and 字段名 BETWEEN '{$a}' AND '{$b}'";