I have a java program which reads data from an Oracle Database and inserts it into DB2. The reading part is working perfectly fine. However, while inserting the data into DB2, it gives me the following error:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008 COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008
After doing some research, I have come to the conclusion that the error might be due to the fact the I am trying to insert values of the type Timestamp into the DB2 table which expects values of the type Date.
Please correct me if I am wrong.
However, if the above is true, could someone suggest a way in which I can convert the Timestamp values into Date values.
I would really appreciate if someone could point me into the right direction.