tSybaseInput

One Star

tSybaseInput

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
Employee

Re: tSybaseInput

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.