InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 23:16:16 GMT20http://www.teradata.com/teradataforum/Topic11225-11-1.aspxThat format is what we call a time stamp in teradata... this is different from a date data type.And as far I could remember the date object that you supply to jdbc should be a java.sql.Date object ... (though I can't confirm from the top of my mind)Tue, 15 Apr 2008 21:08:43 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11225-11-1.aspxHi,I have some problem inserting date into db field which is type of Date.From java code side i can see prepareStatement debug information and there is Date object which is formated as yyyy-mm-dd hh:mm:ss - Ibatis framework prepare this itself and i have no influence on this. The community of this framework informed me, that it is jdbc driver task to automatically translated into correct type, and it should not bother me. But whatever i do, there is always a message : .JDBCException: [NCR] [Teradata DBMS] : Invalid date supplied for TABLE_NAME.DATE_FIELD_NAME.Where is the problem?Thanks for answerTue, 15 Apr 2008 05:07:59 GMTRadek