I am having a problem inserting a date into a TIMESTAMP field. The field in
the database is exactly 8 hours ahead of the Date object I am inserting. My
insert statement is:

<insert id="insertScanOrder" parameterClass="scanOrder">
  INSERT INTO scanorder (clo1, col2, scn_date) values (#value1#, #value2#,
#scanOrderDate:TIMESTAMP#)
</insert>

I am using Ibatis version 2.0, PostgreSQL 7.4.6 with the postgres driver.

Thanks,

Warren Bell

Reply via email to