错误代码:1301 数据集配置错误Query:ORA-01861: 文字与格式字符串不匹配,怎么解决,
select
a.akc191,
a.aac003,
a.aae135,
a.aae072,
a.ake010,
a.aae140,
a.aka130,
b.akf002,
b.bkc192,
b.akc273,
b.bkc194,
b.aac004,
a.bke001,
b.bkc232,
b.AAC009,
c.aaa103,
a.aae140,
a.aka130,
a.akc264,
a.ake300,
a.ake301,
a.ake302,
a.ake303,
a.ake304,
a.ake305
from
nxsiwk.kc24 a,nxsiwk.kc21 b,nxsiwk.aa10 c
where a.akb020='00000001' and a.ckc126='1'
and a.ake010 between '${jsrq}' and '${jsrq2}'
${if(len(jbjg)==0,"","and a.aab034='"+jbjg+"'")}
${if(len(yllb)==0,"","and a.aka130='"+yllb+"'")}
${if(len(xzlb)==0,"","and a.aae140='"+xzlb+"'")}
${if(len(ks)==0,"","and b.akf002='"+ks+"'")}
${if(len(zyh)==0,"","and a.akc191='"+zyh+"'")}
${if(len(ys)==0,"","and b.akc273='"+ys+"'")}
${if(len(sfzh)==0,"","and a.aae135='"+sfzh+"'")}
and a.akc190=b.akc190
and a.bab034=c.aaa102
and c.aaa100='AAB034' 这是我的sql