直报数据总览.cptselect date_format(assigned_date,'%Y-%m-%d') assigned_datefrom(select adddate('2014-01-01',t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) assigned_datefrom(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0,(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1,(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2,(select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3) cwhere assigned_date between "'"+${datastart}+"'" and "'"+${dataend}+"'"where assigned_date between '2020-04-01' and '2020-04-14'我在搜索时间节点这里 添加时间参数。但是一直搜索出来是空的。 把这段sql放到navicat里面执行就可以获取到数据。请问我该怎么才能让他可以根据参数查询数据呢