SQL 中 to_char(SORTRESTIMESTAMP,"+"'"+"yyyy-mm-dd hh24:mi:ss"+"')"+" between "+"'"+starttime+"'"+" and "+ "'"+endtime+"'" 不起作用 SORTRESTIMESTAMP为oracle 时间戳字段TIMESTAMP(6),如果SORTRESTIMESTAMP为时间字段 OK SQL 代码片段: WHERE CMDSTATUS=70 AND SORTRESULTSORTER='Successful Sort.' AND PHYSICALSORTERCODE='DSPSORTER' and 1=1 ${if(len(barcode)> 0,"and barcode ='"+barcode+"'", "and to_char(SORTRESTIMESTAMP,"+"'"+"yyyy-mm-dd hh24:mi:ss"+"')"+" between "+"'"+starttime+"'"+" and "+ "'"+endtime+"'") } |