${if(len(date)=0,"","and time = '"+ date +"'")}
我想在这里面加这两个条件怎么加 date>=time and date<=time1
${if(len(starttime)=0,""," and time>='"+starttime+"'")}
${if(len(endtime)=0,""," and time<='"+endtime+"'")}
time是时间字段,starttime,endtime是开始时间和结束时间参数
${if(len(date)=0,"","and time1 >= '"+ date +"' and time <= '"+date+"'")}