topic Re: Too much time on this problem (java.sql.SQLException: Conversion failed when converting date and/or time from character string) in Talend Studio

Too much time on this problem (java.sql.SQLException: Conversion failed when converting date and/or time from character string)

Anonymous — Fri, 15 Sep 2017 15:54:22 GMT

I have a very persistent error that I have detailed in the attached PDF. Thanks so much for any help!

Allen

TRF — Fri, 15 Sep 2017 17:21:57 GMT

You may convert the input dates as String then use the result for the comparison:

select convert(varchar(19), yourDateColumn, 120) AS date1

Also the inner join seems strange to me, but no time left to analyze in detail.

Should "SELECT ... ON xxxxxx WHERE date1 > '" + (String)globalMap.get("foo") + "'".

No?

Anonymous — Wed, 20 Sep 2017 14:58:59 GMT

The solution kindly provided stopped errors, but the date format still was not bringing correct results.

I finally had to keep the date as a date and not a string and use this to make it work correctly:

AND A.[DATE_ADDED] > ' " + TalendDate.formatDate("yyyy-MM-dd hh:mm:ss", (Date)globalMap.get("maxDate")) + " '

Thanks for your help