Hi, the ISO timestamp format used by SAP DB is 'YYYY-MM-DD HH:MM:SS.MMMMMM' (eg. '1999-01-23 14:30:08.456234'). But depending on the type of the java variable do you use the JDBC driver makes some conversion. A jdbc trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) would be helpful to see more details.
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP Labs Berlin > -----Original Message----- > From: J Sibley [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 11. Dezember 2003 18:15 > To: [EMAIL PROTECTED] > Subject: SAPDB / SAP Business Connector / jdbc / timestamp help > > > I'm trying to insert a row into a SAPDB table using the SAP Business > Connector middleware (it's actually made by WebMethods) and > it's failing > because of a timestamp value I'm passing. The specific error is > "com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB:Cann > ot convert > data to type Timestamp." > > The value being passed is in the format "yyyy-MM-DD HH:mm:ss" > (example: > "2003-12-11 11:10:53") and the SAPDB parameter > "DATE_TIME_FORMAT" is set > to "ISO". The SAP Business Connector is connecting to SAPDB > using the > JDBC driver and I'm using the "pub.db:execSQL" SAP BC flow service to > execute the SQL statement. > > Any ideas anyone? > > Thanks > > Jim Sibley > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
