All
Try to user tSybaseInput and have the same probleme white date format (DB Sybase 12.5)
Exception in component tSybaseInput_2 java.sql.SQLException: JZ009: L'erreur suivante a été détectée pendant la conversion : java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source) at com.sybase.jdbc3.jdbc.Convert.objectToTimestamp(Unknown Source) at com.sybase.jdbc3.jdbc.Convert.objectToDateObject(Unknown Source) at com.sybase.jdbc3.tds.TdsJdbcInputStream.getDateObject(Unknown Source) at com.sybase.jdbc3.jdbc.SybResultSet.getTimestamp(Unknown Source) at an.j_01_alim_extractionperimetre_na.J_01_ALIM_ExtractionPerimetre_NA.tSybaseInput_2Process(J_01_ALIM_ExtractionPerimetre_NA.java:242) at an.j_01_alim_extractionperimetre_na.J_01_ALIM_ExtractionPerimetre_NA.runJob(J_01_ALIM_ExtractionPerimetre_NA.java:491) at an.j_01_alim_extractionperimetre_na.J_01_ALIM_ExtractionPerimetre_NA.main(J_01_ALIM_ExtractionPerimetre_NA.java:435)
I have a simple table with
Product varchar(20)
StartDate datetime
trying to use this table with tmap and I get this error message
I trying to convert the datetime with TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",row1.StartDate ) but is not working
I changed the Date Pattern in the Schema is not working
Please help
DN
Hello Denis,
Just an idea, can you try with TalendDate.formatDate("yyyy-MM-dd HH:mm:ss.SSS",row1.StartDate ) to get the missing milliseconds of the pattern ?
Regards,
Michaël.
