oracel对日期格式要求严格。要严格按格式来的。。

select distinct T1.CHARGENNR CHARGENNR,T1.ZEITPUNKT,T3.DTCCPROD from PM T1,

(SELECT  HEATNO,MIN(PSTNGDATE) PSTNGDATE,MIN(DTCCPROD) DTCCPROD FROM V_261FORBILLET_INFO GROUP BY HEATNO)t2,

(select HEATNO,MIN(DTCCPROD) DTCCPROD from MAT where  ERPLAGERORT='2102' and typ='KV' GROUP BY HEATNO)T3

where  T1.CHARGENNR = T3.HEATNO

and t1.CHARGENNR=t2.HEATNO(+)

and T1.AGTYP='LF'  

and to_char(T1.ZEITPUNKT,'YYYY-MM-DD hh24:mi:ss')>='${starttime}' 

and to_char(T1.ZEITPUNKT,'YYYY-MM-DD hh24:mi:ss')<'${endtime}'

${if(len(ttype)==0,"",if(ttype='生产时间',"and to_char(T1.ZEITPUNKT,'YYYY-MM-DD hh24:mi:ss')>=to_char(to_date('"+starttime+"','yyyy-mm-dd'),'YYYY-MM-DD hh24:mi:ss') 

and  to_char(T1.ZEITPUNKT,'YYYY-MM-DD hh24:mi:ss')<to_char(to_date('"+endtime+"','yyyy-mm-dd'),'YYYY-MM-DD hh24:mi:ss')",

if(ttype='连铸生产时间',

"and to_char(t3.DTCCPROD,'YYYY-MM-DD HH:MI:SS')>='"+starttime+"' and to_char(t3.DTCCPROD,'YYYY-MM-DD HH:MI:SS')<'"+endtime+"'",

"and to_char(t2.PSTNGDATE,'YYYY-MM-DD HH:MI:SS')>='"+starttime+"' and to_char(t2.PSTNGDATE,'YYYY-MM-DD HH:MI:SS')<'"+endtime+"'")))} 

order by T1.CHARGENNR asc

数据集预览报不报错

https://blog.csdn.net/xiaochenXIHUA/article/details/120240380