用户cfDDG9086548(提问者)where 1=1 ${if(len(starttime)=0,\"\",\" and y.creationTime>=\'\"+starttime+\"\'\")}${if(len(endtime)=0,\"\",\" and y.creationTime<\'\"+endtime+\"\'\")} y.creationTime 这个是系统创建得时间
Z4u3z1 回复 用户cfDDG9086548(提问者)第二个用小于等于啊
where 1=1 ${if(len(starttime)=0,\"\",\" and y.creationTime>=\'\"+starttime+\"\'\")}${if(len(endtime)=0,\"\",\" and y.creationTime<=\'\"+endtime+\"\'\")}