CREATE OR REPLACE FUNCTION "CQMS"."RPT_RETURN_CCCS_SJ" (plate_number in varchar(200),statrtDate in varchar(200),endDate in varchar(200)) return int is
--计算出车次数
Result int;
vs_sql varchar(4000);
where_sql varchar(200); -- where条件拼接
begin
where_sql:= ' (t.car_leave_time >= STR_TO_DATE('''||statrtDate||''',''yyyy-MM-dd'') and t.car_leave_time < STR_TO_DATE('''||endDate||''',''yyyy-MM-dd'')+1) ';
vs_sql:=vs_sql +' SELECT ISNULL (sum(count(t.plate_number) ),0) FROM ljl_new_sheet_t t WHERE t.plate_number ='''||plate_number||''' and '||where_sql||' group by STR_TO_DATE(t.car_leave_time,''yyyy-MM-dd'')';
execute immediate vs_sql into Result;
return(Result);
end RPT_RETURN_CCCS_SJ;