oracle 介于日期之间_ORA-01841: (完整) 年份值必须介于 -4713 和 +9999 之间, 且不为 0...

2005042800000018

1020061019000310

2013-01-22

2013-01-22

2013-12-31

102011010700000016

4301-4700?ó?¨/?§??

3

Hibernate: select xsjgmb0_.row_id as row1_48_, xsjgmb0_.created_by as created2_48_, xsjgmb0_.created_date as created3_48_, xsjgmb0_.last_upd_by as last4_48_, xsjgmb0_.last_upd_date as last5_48_, xsjgmb0_.modification_num as modifica6_48_, xsjgmb0_.taxis_no as taxis7_48_, xsjgmb0_.begin_date as begin8_48_, xsjgmb0_.end_date as end9_48_, xsjgmb0_.prod_type_id as prod10_48_, xsjgmb0_.prod_type as prod11_48_, xsjgmb0_.coal_type_id as coal12_48_, xsjgmb0_.coal_type as coal13_48_, xsjgmb0_.coal_level as coal14_48_, xsjgmb0_.province_id as province15_48_, xsjgmb0_.province as province48_, xsjgmb0_.customer_id as customer17_48_, xsjgmb0_.customer as customer48_, xsjgmb0_.madefrom_id as madefrom19_48_, xsjgmb0_.madefrom as madefrom48_, xsjgmb0_.coal_price as coal21_48_, xsjgmb0_.price_unit_id as price22_48_, xsjgmb0_.price_unit as price23_48_, xsjgmb0_.using_flag as using24_48_, xsjgmb0_.remark as remark48_, xsjgmb0_.contract_temp_id as contract26_48_, xsjgmb0_.prod_spec_id as prod27_48_, xsjgmb0_.pricing_type_id as pricing28_48_, xsjgmb0_.pricing_type as pricing29_48_ from SMD_CONTRACT_PRICE_TEMP xsjgmb0_ where 0=0 and xsjgmb0_.using_flag='Y' and (MADEFROM_ID is null) and (xsjgmb0_.province_id is null) and (xsjgmb0_.pricing_type_id like '%2005042800000018%') and (xsjgmb0_.customer_id like '%1020061019000310%') and (to_char(to_date('%2013-01-22%', 'yyyy-mm-dd')) between '%2013-01-22%' and '%2013-12-31%') and (xsjgmb0_.prod_type_id like '%102011010700000016%') and (xsjgmb0_.coal_level like '%4301-4700?ó?¨/?§??%') and (xsjgmb0_.coal_level like '%3%') order by xsjgmb0_.prod_type_id, xsjgmb0_.coal_type_id, xsjgmb0_.coal_level

10:30:19,266 ERROR org.hibernate.util.JDBCExceptionReporter:101 - ORA-01841: (完整) 年份值必须介于 -4713 和 +9999 之间, 且不为 0

org.springframework.dao.DataIntegrityViolationException: could not execute query; nested exception is org.hibernate.exception.DataException: could not execute query

at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:639)

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)

at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)

at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:913)

at com.highcom.htgl.dao.impl.XsjgMbImpl.getXsjgMbList(XsjgMbImpl.java:38)

at com.highcom.htgl.service.impl.InfoServiceImpl.getMkjjList(InfoServiceImpl.java:542)

at sun.refl