Created a temporary session table and use the data to insert into heap and x100 table. Upon doing a select statement, it gives E_US10D7 error and looks like the inserted value was an invalid date, however the value on temporary session table was valid. Apparently, it?s a bug with ID II-7036, 137473 and solved with Ingres 11.1 Patch 15615.