无效月份

[cai_jim_xiaoniu]

select * from (select rownum no, au.* from (select a.*,u.*,floor(months_between(SYSDATE, to_date(case when length(a.TB_ADMIN_BIRTHDAY)>2 then a.TB_ADMIN_BIRTHDAY else '2017-01-01' end,'yyyy-mm-dd'))/ 12) as age from tb_Admin a inner join (select DISTINCT adminid,jieci from admindeptjc where dutycode is not null and jieci = 12245) ad on a.tb_admin_id = ad.adminid left join tb_user u on u.tb_user_id = a.tb_admin_id left join duty d on a.dutycode = d.code where a.TB_ADMIN_LOGINNAME <> 'admin' and a.TB_ADMIN_STATUS = 's' and u.tb_user_status = 's' and a.TAG is null order by orderno ) au) x where x.no > 0 and x.no <= 30

[cai_jim_xiaoniu]

今天土人不好用了，我也是懵逼

[js14982]

a.TB_ADMIN_BIRTHDAY 是什么格式？你to_date，表示你 a.TB_ADMIN_BIRTHDAY为char类型才可以to_date

[cai_jim_xiaoniu]

varchar的

[js14982]

那就是a.TB_ADMIN_BIRTHDAY里面有不符合月份标准的数据，比如2016-14-01这样的，不符合月份标准

[cai_jim_xiaoniu]

找到问题了，数据库中有个7898-76-54月份，醉了；感谢