请教下各位老师,要用数据集参数刷选出某个时间段的数据,写的sql是这样的select * from cxhnweixin.FPV_FARM_PAY_VOUCHER
where status ='finish'
${if(len(starttime)=0,""," and finish_time>='"+starttime+"'")}
${if(len(endtime)=0,""," and finish_time<'"+endtime+"'")}
但是设置参数后显示文字与格式字符串不匹配,看了下数据,里面的finish_time格式是yyyy-MM-dd HH-mm-ss,我估计是我时间格式没设置好,但是又不知道怎么设置,来请教下各位老师

(纯新人自己看教程摸索,无人教,小白地方请见谅)