直接上例子吧

FROM_UNIXTIME(字段,’%Y-%m-%d’)

$temp_data['alreadyharvest'] = $model->table(C(‘DB_PREFIX’).’linkharvest’)->where(“`aid` = ‘”.$temp_data['aid'].”‘ and FROM_UNIXTIME(harvestinputdate,’%Y-%m-%d’) = ‘”.date(‘Y-m-d’, time()-86400).”‘”)->sum(‘alreadyharvest’);//例子一枚