| sql报错：ORA-01830: 日期格式图片在转换整个输入字符串之前结束 sql语句： select distinct(slj_info.id),lettertype,lettersrc,slj_zhuanban.nibandate,titlename ,slj_zhuanban.loginname,nibandate,slj_zhuanban.ext2, slj_zhuanban.limitdate,to_date('2018-08-22','yyyy-mm-dd') time, to_date(slj_zhuanban.limitdate,'yyyy-mm-dd') t --问题 from slj_info ,slj_zhuanban,slj_nibanunit where slj_info.id=slj_zhuanban.letterid and slj_info.id=slj_nibanunit.letterid and letterstate=1 and zbstate=1 and zbclass=0 and nbstate=0 order by slj_zhuanban.nibandate desc 但是单独拉出来执行 select to_date(slj_zhuanban.limitdate,'yyyy-mm-dd') t from slj_zhuanban 显示正常，请问各位老师是什么原因 |
