${if(len(time4) == 0,"","

SELECT

SUM(IFNULL(number,0)) AS 数量,

SUM(IFNULL(amount,0)) AS 金额,

'" +time4 + " 23:59:59' AS 时间

FROM

(SELECT * FROM business_engineering_insert WHERE dateTime =LEFT('" +time4 + " 23:59:59',10) AND type = 0 ) a

RIGHT JOIN ( SELECT id, NAME FROM fine_department WHERE id > 22 AND id < 44 ) b ON a.tableDep = LEFT ( b.`name`, 2 ) 

GROUP  BY

dateTime  ")}

UNION

${if(len(time3) == 0,"","

SELECT

SUM(IFNULL(number,0)) AS 数量,

SUM(IFNULL(amount,0)) AS 金额,

'" +time3 + " 23:59:59' AS 时间

FROM

( SELECT * FROM business_engineering_insert WHERE dateTime =LEFT('" +time3 + " 23:59:59',10) AND type = 0 ) a

RIGHT JOIN ( SELECT id, NAME FROM fine_department WHERE id > 22 AND id < 44 ) b ON a.tableDep = LEFT ( b.`name`, 2 ) 

GROUP  BY

dateTime  ")}

----大概是这个样子。另外dateTime =LEFT('" +time3 + " 23:59:59',10)为什么这个要加个时间然后再left 这不是time3的年月日么？把time3设置成数据库中的日期格式，再返回字符串不就完事了...

给你一个参考，你这个sql其实可以写成两个数据集，再用关联数据集union起来