https://community.qlik.com/t5/Talend-Studio/Error-in-Talend-Open-Studio-Exception-in-component-tDBInput-1-t1/m-p/2265613#M45095 <P>Hello,</P> <P><SPAN>Can you please clarify in which Talend version/edition you are?</SPAN> Screenshots of your job setting will be preferred.</P> <P>Best regards</P> <P>Sabrina</P> Mon, 17 Sep 2018 09:59:54 GMT Anonymous 2018-09-17T09:59:54Z https://community.qlik.com/t5/Talend-Studio/Error-in-Talend-Open-Studio-Exception-in-component-tDBInput-1-t1/m-p/2265612#M45094 <P>I am using PostgreSQL which has two date columns with data type as "character varying". When I connect Talend and try to read the data. it gives me the below error:&nbsp;Exception in component tDBInput_1 (t1) org.postgresql.util.PSQLException: Bad value for type timestamp : 2006-03-24-09.45.00.000000. Even if I try to change the data type to string or use the available date patterns, it still shows the same error. Please let me know how to deal with this if I do not want to change the datatype at the DB level.</P><P>&nbsp;</P><P>Thanks!!</P><P>&nbsp;</P> Thu, 06 Sep 2018 09:15:48 GMT https://community.qlik.com/t5/Talend-Studio/Error-in-Talend-Open-Studio-Exception-in-component-tDBInput-1-t1/m-p/2265612#M45094 Anonymous 2018-09-06T09:15:48Z https://community.qlik.com/t5/Talend-Studio/Error-in-Talend-Open-Studio-Exception-in-component-tDBInput-1-t1/m-p/2265613#M45095 <P>Hello,</P> <P><SPAN>Can you please clarify in which Talend version/edition you are?</SPAN> Screenshots of your job setting will be preferred.</P> <P>Best regards</P> <P>Sabrina</P> Mon, 17 Sep 2018 09:59:54 GMT https://community.qlik.com/t5/Talend-Studio/Error-in-Talend-Open-Studio-Exception-in-component-tDBInput-1-t1/m-p/2265613#M45095 Anonymous 2018-09-17T09:59:54Z